Sum of Rows in Text Box

[#1]

Hi ,

Is there anyway to replicate the Sum of Rows in a Straight chart into a Text Box.

The problem I am facing is,the Total of an Expression is different when you individually calculate the expression for each quarter.

Any help would be greatly appreciated

[#2]

Sorry Sunny....tried that but it returns 0 for some reason.

sum(aggr(sum({<Scenario={'Actual'}>}Clms_Vol)*sum({<Scenario-={'Actual'}>}Unit*sum({<Scenario-={'Actual'}>}UnitPrice)),Quarter))

The above is what I require,unfortunately its not giving any output

[sunny_talwar · Accepted solution]

I don't know if this is a copy paste error, but you are missing a parenthesis here:

Sum(Aggr(

              (Sum({<Scenario={'Actual'}>}Clms_Vol) *

              Sum({<Scenario-={'Actual'}>}Unit) *

              Sum({<Scenario-={'Actual'}>}UnitPrice)),

      Quarter))

[#4]

its not taking the third expression for some reason

[#5]

I think,it was the problem with the fields and the setanalysis condition....but it works fine now...Thanks Sunny