Grand Total did not Add Up for Calculated Measures

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

Currently, I had managed to create measures for Current Year and
Previous Year, I managed to do that with the statement below. However,
I do have problem at the Grand Total for the column Previous_Year, the
amount always shown as 0.

Previous_Year:
iif([DIM_UW_Year].CurrentMember.Level.Ordinal > 0,
([Measures].[Renewal Policy Premium], ParallelPeriod([DIM_UW_Year].[Uw
Year])),0)

Thanks in advance for your help.

regards,
Mangorind

.

Relevant Pages