1. I am trying to calculate Minimum cost , Maximum cost, Average cost per Item.
2. In my Sales Table, I have Total cost and Quantity column
3. I have used Divide Function to Total cost/ Qty = Get Unit price( giving wrong output)
4. When I am applying MIn/ Max to calculated column , I am not getting true value
5. When I am calculating unit price measure I am getting right answer for Unit price. But I am not able to apply MIN/MAX function to measure.
Can anyone please help me
Solved! Go to Solution.