1 Reply Latest reply: Jun 18, 2016 7:59 AM by PAUL YEO RSS

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

    PAUL YEO

      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