Hi,
We calculate amount by multiplicating <b>Net Price</b> with <b>Order Quantity</b>.
But since the currency of price is for example <b>EUR</b> and the unit of quantity can be <b>Box, Set, Each</b>, etc, we can't sum the amount for all amount records, since some of them are <b>EUR Box</b>, some <b>EUR Set</b>, some <b>EUR each</b>, etc.
How can we get rid of the quantity unit and just calculate amount ?
Thanks in advance,
GSE
You can set in your formula that quantity is a number without unit. (This is one of the functions in the right pane of the formula builder). Then you will see only EUR.
The formule will then look like this:
NODIM(Order Quantity) * Net Price
Add a comment