I am currently doing a comparison between YEAR on YEAR change data. Bascially a Jan 2012 column is derived from the differences of Jan 2012 and Jan 2011. The data that I got is correct but however, it list out all the Dimension even though is blank.
Here is my code,
=if( Before( Sum (IF(Status <> 'LHP', TEU,0)) , 12) = 0 OR IsNull( Before( Sum (IF(Status <> 'LHP', TEU,0)) , 12)) = -1, null(),
if( MonthEnd ( MAX( Date ) ) <> var_EndDate AND MonthEnd( MAX ( Date ) ) = MonthEnd( var_EndDate ) , Sum({< Class= {'Lade'} ,Status = {'TP'} ,Loading = {'ID*'} >} TEU / Day( var_EndDate )) * Day(MonthEnd(MAX ( Date )))