7 Replies Latest reply on Jul 6, 2018 6:02 AM by Zhouyi Zhang

    How to get previous month's value if there is no value of the selected Reporting Period?

    Wayne Ooi

      Hi,

       

      I am trying to populate the value of previous month's data (up to the last 3 periods, including selected Reporting Period) if there is no value for the selected Reporting Period.

      I managed to use DATEADD() Function to look for previous period's data and also have tried using IF THEN ELSEIF ... but not able to achieve what I need.

      Would appreciate if someone could show me how to achieve this. Thanks.

       

      Thanks,

      Wayne.