Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have below expression from sunny :-
If(Month(Date(Max({<sales = {'>0'}>}Date))) = 12, 365, ((Month(Date(Max({<sales = {'>0'}>}Date))) + 0) * 30))
Above work fine , when dimension = YEAR. ( Table 1 ).
When i change my dimension to YearMonth , i want Days display 30 days. ( Table 2 )
Hope some one can advise me how to achieve this ?
Paul
My QVF Doc