1 Reply Latest reply: Aug 17, 2016 5:28 AM by Gysbert Wassenaar RSS

    If else or set analysis?

    Philip Radovich

      Hi,

       

      I have the following script to calculate the percentage change based on performance item and assessment dates.

      (FirstSortedValue(Value/100, -AssessmentDate)-FirstSortedValue(Value/100, AssessmentDate))/FirstSortedValue(Value/100, AssessmentDate). This works for the most part but different values are based on different units of measure. I have a column in my database that is called Reverse which is a 1 or a 0 based on whether the unit of measure is a time or a count of the performance item. I am struggling to write a script in the app that can calculate this percentage change and display the correct results based on the Reverse column. Any help would be greatly appreciated.

       

      Thank you,

       

      Philip Radovich