Calculated dimension

[#1]

Hello, guys!

I need to create a calculated dimension  with condition in my straight table.

I've created the dimension like  :

=aggr(if(Sum({<Month_Date={"=$(=max(Month_Date))"},Month_name=>} Bench_Data)>0,

Sum(Bench_Data)/$(vNoOfMonths)),Emp_name)

But that part with set analysis doesnt seem to work.

May be I have some syntax error?

Please correct me!

[sunny_talwar · Accepted solution]

Try this may be:

=Aggr(If(Sum({<Month_Date={"$(=Max(Month_Date))"}, Month_name=>} Bench_Data) > 0,

Sum(Bench_Data)/$(vNoOfMonths)), Emp_name)