4 Replies Latest reply on May 24, 2016 1:21 PM by vinutha vasanthu

    Calculated field not working as expected

    vinutha vasanthu

      The below mentioned is the calculation field to fetch the prior months.

       

      This is the calculation i used.

      CASE [TimeFrame]

      when 'DateMonth' then if [Months between today and Date]=0 then 'show' end

      when 'Last2Months' then if [Months between today and Date]>=0 and [Months between today and Date]<=1 then 'show' end

      when 'Last3Months' then if [Months between today and Date]>=0 and [Months between today and Date]<=2 then 'show' end

      else 'hide'

      end

       

      The above mentioned Calculation is working as expected for Last2Months and Last3Months but its not showing any result for the current month

       

      Example if the user selects 11/1/2015 then

      DateMonth should be November--currently no data is shown...

      Last2Months should be November and October--working as expected

      Last3Months should be November,October and September --working as expected.

       

      Also i need to add up the months as rolling sum and display automatically instead of the drop down selected.

       

      Please find the twbx attached.

       

       

      Any inputs would greately be appreciated.

       

       

       

       

      Thanks

      Vinutha