Aggregated function when used in Bar chart doesnt work properly when used inside a variable

[kusha_2007]

Hello All , 

I have a bar chart with Dimension as MonthYear and my Measure  is sum(AGGR(Count (distinct InteractionCallDate), AccountPlanOwnerID,CountryCode,MonthYear)). When I store the above calculation in a variable and use the variable in the Chart , the result is not correct . it gives the total sum for all the months .

If  I Use the calculation directly in the chart , it behaves properly . 

I hope I am able to explain the issue correctly .  I am not able to figure why its not working properly when used inside a variable.

[marcus_sommer · Accepted solution]

Make sure that your variable-content looked like:

sum(AGGR(Count (distinct InteractionCallDate), AccountPlanOwnerID,CountryCode,MonthYear))

and not

= sum(AGGR(Count (distinct InteractionCallDate), AccountPlanOwnerID,CountryCode,MonthYear))

The essential difference is the leading equal-sign.

- Marcus

[kusha_2007 · Accepted solution]

Thanks a lot...