I'm struggling to resolve an issue I have with a calculated measure returning a positive value when it's calculating using two negative inputs.
We issue out materials to order numbers and I want to calculate the total value of materials issued to orders. There are two input measures that work as they should: Material Quantity and Unit Price. The final measure I'm struggling with is called Extended Price: Extended Price = [Unit Price]*[Material Quantity].
This works fine when the Unit Price or Material Quantity are positive numbers, however the problem is when either are negative (when a material item is removed or credited off an order number it will display in the transaction as a negative. This in itself is fine but I need the calculated Extended Price measure to reflect the negative result and currently when both the Unit Price and Material Quantity are negative, the Extended Price result is showing as positive.
Am I missing something here, and what can anyone suggest that I do to ensure the Extended Price returns a negative value when either or both the Unit Price or Material Quantity are negative (usually it's both negative).
I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support. Best Regards, Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.