4 Replies Latest reply: May 15, 2014 10:09 AM by ChristD _ RSS

    No functions in summaries for custom Measure Expression

    ChristD _

      I wanted to use an "If"-statement in a custom measure Expression but concluded that this was not possible.

       

      I needed it because the calculated result using "SUM" for two measures and one by the other does not give the required result. I use to calculate a forecast accuracy number and the "If" function is crucial part to get the desired result. In the table view this is possible of course, but I had hoped that this would possible in the summary window as well.

       

      Maybe there is there another way to get to the required result in Monarch?

       

      Thanks for your help,

      Christ