When Dimension = Year , Expression Day can display 365 , How to make when Dimension = YearMonth , Days display 30 days ?

[paulyeo11]

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

[paulyeo11]

My QVF Doc