Aggregation summary of Price Diff (Current Month - Previous Month)

[maxloveiii]

Hello,

I attempted to create an expression for calculating the summary of price changes between the Current Month and Prior Month over a span of one year. However, when I applied aggregation to summarize the data, the function yielded an incorrect result. I'm seeking suggestions on how to address this issue. Unfortunately, fixing it in the load script is not feasible because the design involves comparing prices from various sources.

Sum(Aggr(Avg([TP Act.]) - Above(Avg([TP Act.])),[TP Cust],[TP Mat], [TP Curr],TPMonth))

Thank you in advance.

[Anil_Babu_Samineni]

@maxloveiii I wonder why this is highlighted? Also, It is good to show the expected result as well.

[maxloveiii]

@Anil_Babu_Samineni 

I apologize for the unclear question.

Desired outcome: Price - A = B. However, when I utilized the expression F, the result by row appears to be incorrect. I may have overlooked something. Can you please point out any mistakes I might have made?

[Anil_Babu_Samineni]

@maxloveiii I believe B,C,D and F are your test expressions and you indeed needed only one expression. 

If so, please select 2 or 3 months and share the outcome what you expect. Because, I assume there is something missing in Above().

[maxloveiii]

@Anil_Babu_Samineni Indeed, you are right. I am looking for a single expression that I can utilize in another chart. Please refer to the example below for clarification.

[Anil_Babu_Samineni]

@maxloveiii Try with Above(Total ..)

[maxloveiii]

@Anil_Babu_Samineni Thank you for your prompt response. I attempted to follow your suggestion, but I'm still encountering incorrect results. Perhaps I should explore alternative solutions that don't rely on the Above() function.

[Anil_Babu_Samineni · Accepted solution]

@maxloveiii We all helping on assumption bases only, I would suggest to share sample data set to check in detail where the problem can found or to demonstrate.