2 Replies Latest reply: Sep 5, 2016 9:07 AM by Tom Neal RSS

    Expresion If Flag + condition then result.

    Tom Neal

      Hello,

       

      I've created an expression to show the total % only for rows which are flagged as between 0-7 days
      and where the total % is less than 0.3.  Below is the formular which I have put together however it returns blank where
      it should be returning the Total %.

       

      IF(MAX({<[0-7DayFlag]={"True"}>}[Total%])<'0.3', MAX({<[0-7DayFlag]={"True"}>}Total%])

       

      Could someone point out what is the issue with the expression?

       

      Thanks in advanced.

      Tom

        • Re: Expresion If Flag + condition then result.
          Sunny Talwar

          May be try this:

           

          If(Max({<[0-7DayFlag] = {'True'}>} [Total%]) < 0.3, Max({<[0-7DayFlag] = {'True'}>} [Total%])

           

          If that doesn't help, would you be able to provide a sample to take a look at?

          • Re: Expresion If Flag + condition then result.
            Tom Neal

            Thanks for the response,

             

            I actually moved away from this formula due to not receiving the correct outcome.

             

            I am now using the following:

             

            if(Aggr(

            Sum({<[0-7DayFlag]={"True"}>}[Total1]+[Total2]+[Total3]+[Total4]) /

            Sum(Products), Store, Area)<'0.3',

            Aggr(

            Sum({<[0-7DayFlag]={"True"}>}[Total1]+[Total2]+[Total3]+[Total4]) /

            Sum(Products), Store, Area))

             

            This is showing me the results for all 0-7 day rows where as I only want to see the rows where the outcome of the calculation is less than < 0.3.

             

            I don't know why but it seems that the <'0.3' is being ignored in the if statement.