Multiplying Cases by USD in Key Figure. How to get rid of CS in the result
I have a formula where I am multiplying a quantity by an amount. Both have unit/currency attached to it.
For example : Quantity is 5 CS and Amount is $2.00
I have a formula Total = Quantity * Amount
Results are displaying like $ 10.00 CS. I need just $ 10.00 to display
How can I divide the formula by CS .. I have tried replacement path variable assigned value of 1 and unit of CS but that doesnt seem to work.. (unless Im using wrong settings)
Also adding a dummy key Figure = 1 CS for all records in backend objects and then using it to divide doesnt sound as the best solution
Can you please advice? Thanks in advance!
Total= Quantitity* NO DIM( Amount) or take a dummy keyfigure of amount with out curreency.