3 Replies Latest reply on Dec 19, 2015 11:24 PM by Muralidhar Areti

    Change Calculation labels dynamically

    Venkata Krishna

      Hi,

       

      I have 2 calculations which are for months and want to change them dynamically.

       

      First Calculation: Previous Month

       

                 IF

                    DATEDIFF('month',[Date],TODAY())=1

                 THEN

                    [ABC]

                 END

       

      Instead of ‘Previous Month’ I want to display it as ‘Nov 15’ and this has to change dynamically every month.

       

      Second Calculation: Start Month where Start Month=Current Month-3

       

       

                 IF

                     DATEDIFF('month',[Date],TODAY())=3

                THEN

                     [ABC]

                END

       

      Instead of ‘Start Month’ I want to display it as ‘Sep 15’ and this has to change dynamically every month.

       

      Please advice

       

      Venkata