Calculated dimension

Mon, 10 Aug 2015 14:33:55 GMT

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!

Re: Calculated dimension

sunny_talwar — Mon, 10 Aug 2015 14:38:16 GMT

Try this may be:

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

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