WHEN Subtotal > Medium Order THEN Subtotal * Medium Order Discountįor this solution, we've created separate fields to hold values for large and medium sized orders and corresponding discounts. WHEN Subtotal > Large Order THEN Subtotal * Large Order Discount It keeps the main logic in a single field, while breaking out some of the dependent logic into separate fields: This solution blends the 2 approaches described above. For example, say you had 10 product tiers with different order quantity thresholds? Or say you wanted to use the same discounts for a different product line? In these cases, it might be easier or more efficient to use separate fields for those thresholds and discounts. But you also might have to do a lot of repetitive typing, and a complex formula may be harder to extend or maintain. On the other hand, centralizing all the logic into one field can make simple formulas easier to understand and edit. One drawback to creating formulas with lots of discrete calculated fields is that it may not be obvious what each one does, so you'll need to edit them individually to see how they are calculated or make changes. For example, using a separate field for the discount rate lets you use that field in other calculations or display it in your reports.
![caterpillar serial number guide tutorial caterpillar serial number guide tutorial](https://i.ytimg.com/vi/td5bnODlApQ/maxresdefault.jpg)
Separate fields can also be useful in more contexts. There are pros and cons to each approach:īreaking down complex formulas into separate fields can make your formulas easier to read and write, and less error-prone. WHEN Price * Qty Sold > 100 THEN (Price * Qty Sold) *. WHEN Price * Qty Sold > 499 THEN (Price * Qty Sold) *. For example, you could combine steps 3 - 5 of this tutorial into one field: The solution above breaks the problem up into individual chunks and create discrete fields to handle each chunk, as you've done with the Subtotal, Discount, and Total fields.Īnother approach is to perform all of the calculations in a single calculated field.
![caterpillar serial number guide tutorial caterpillar serial number guide tutorial](https://lasopaturk884.weebly.com/uploads/1/2/6/5/126504559/616518396.png)
#CATERPILLAR SERIAL NUMBER GUIDE TUTORIAL HOW TO#