cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mazharmh Member
Member

Error: Min/Max calculation

Hi All,

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Error: Min/Max calculation

@mazharmh,

 

You may try MINX Function and MAXX Function which evaluate an expression for each row of a table.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Error: Min/Max calculation

@mazharmh,

 

You may try MINX Function and MAXX Function which evaluate an expression for each row of a table.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.