Aggr in Calculated Dimension

[Anonymous]

Hi Guys,

Can someone help me fix this script? I'm encountering an error when i create a calculated dimension in my straight table:

=if(count({<SC_Time_Dim={'M'}, SC_Date_Month= {'$(=Month(MonthStart(num(today()-1))-1))'}, SC_Date_Year= {'$(=Year(MonthStart(num(today()-1))-1))'}>} SC_Metric_KEY)> 0,SC_Stream)

Thanks for the help!

[sunny_talwar]

May be this

Aggr(If(Count({<SC_Time_Dim = {'M'}, SC_Date_Month = {'$(=Month(MonthStart(Num(Today()-1))-1))'}, SC_Date_Year =  {'$(=Year(MonthStart(Num(Today()-1))-1))'}>} SC_Metric_KEY) > 0, SC_Stream), SC_Stream)