1 Reply Latest reply on May 15, 2018 10:58 AM by Jim Dehner

    Stop line curve for running total at current date

    chetan Bhatnagar

      Dear user, i am using following formula for calculation in  my measure to show running total. How i can tweak this to stop at current date for current month. So the line curve stop at current date

       

      IF [data_type]='actual' AND [Cal_Date_New]='Current' THEN [pipeline]

      END

        • 1. Re: Stop line curve for running total at current date
          Jim Dehner

          Hi

          have you tried

           

          IF  if datetrunc('day'',date)) <= datetrunc('day',today()) and

           

           

          [data_type]='actual' AND [Cal_Date_New]='Current' THEN [pipeline]

          END

           

          where date is whatever your actual date is -- cal_date_new?

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          Jim