Hi,
Would really appreciate urgent help with a calculated dimension that i am stuck with.
I have 2 CALCULATED dimensions for a line chart - one customers(top 4 - this is working) and then quarter grouping backwards up to 12 - QTR1, QTR2, QTR3..........QTR12. This calcualted dimension is currently returning null value for the expression sum(sales)
I started testing with one quarter back wards
= IF ([TIME] >= $(vMinMonth1) and [TIME] >= $(vMaxMonth1) ,'daterange1', null() ) currently this is always returning null
my vMinMonth1 variable is working = monthstart( AddMonths(Max(LatestDate), -2))
my vMaxMonth1 variable is working = monthend(AddMonths(Max(LatestDate)))
when i debug is see the values pulling through
= IF([TIME]>= 2014/03/01 and [TIME]<= 2014/05/14 , 'daterange1',null() ) but its showing null values for the sales that happen during this time period
Thank so much
Louw
