Problem with aggregate function

[pkpandey]

Hi All

I have a problem with AGGREGATE function. I am getting the GP value wrong when an item is selected. For example when an item a is selected the GP value should be 2571.429 but it is showing 9000.

Please find the attached QVW for your information.

[sunny_talwar]

What is the logic behind getting 2571.429 here?

[pkpandey]

Hi Sunny

Total GP for the month divided by total sales for the month and multiplied by the sales of that Item for the month

[sunny_talwar]

Try this expression. You overally complicated your expression before

=Sum(Total {<Item>} GP)/Sum(Total {<Item>} Sales) * Sum(Sales)

[sunny_talwar · Accepted solution]

Or this:

=Sum(Total {1} GP)/Sum(Total {1} Sales) * Sum(Sales)

[pkpandey]

Many thanks