Calculated measures

These calculation rules are used for the derived fields:


Name	Calculation Rule
Ship Due Date Difference	`co_ship.ship_date – coitem.due_date`
Date (Ship Date)	`convert co_ship.ship_date to format YYYY/MM/DD`
Due Date	`convert coitem.due_date to format YYYY/MM/DD`
Delivery Interval	`Early if Ship_Due_Date_Difference > 1` `else 1 - 3 days if Ship_Due_Date_Difference between -3 AND -2` `else 4 - 7 days if Ship_Due_Date_Difference between -7 AND -4` `else 8 - 20 days if Ship_Due_Date_Difference between -20 AND -8` `else 20+ days if Ship_Due_Date_Difference < -20 else On Time if between -1 and 1` If there are multiple shipments for one order line, then the last shipment date is used for calculation. For the no shipment order line, set the quantity shipped to 0 and set the shipment date to current date.
Promise Date	`convert coitem.promise_date to format YYYY/MM/DD`
Order Date	`convert co.order_date to format YYYY/MM/DD`
Order Status	Only includes Ordered/Complete/History status, the Planned/Stopped should be excluded.

Multi-currency

Birst uses the current exchange rate to convert the amount to the report currency amount. To get the report currency amount, Birst multiplies the domestic amount by the current rate. If there is no currency rate, then 0 displays.

Calculation:

current rate amount = domestic amount * current exchange rate

If there is no exchange rate, then 0 displays.