6 Replies Latest reply: Nov 19, 2015 11:11 PM by Prashant Sangle RSS

    set analysis question

    Jo Tedesco

      Hi all this works

      - as Classification = Clinical - will not change no matter what Classification is chosen by the user.

      (Sum({$<Classification={'Clinical'}>}DurMins))/Sum({1}AvailMins)

       

      This expression is better because if the week has 2 months - it will still calculate correctly.

      if

       

      (Classification = 'Clinical',((sum({$<WeekNum = p(WeekNum), Date_Fin_Month = >}DurMins))/(sum({$<WeekNum = p(WeekNum), Date_Fin_Month = >}AvailMins))))

       

       

      However, a user needs to make a selection of Clinical.

       

      I would like to make it that a User did not need to select Classification = Clinical but always stays as Clinical.

       

      I have tried combining the two expresssions but it is hard and I end up with commas and brackets left over!

       

      How could I modify the if statement???

      Jo