5 Replies Latest reply on Sep 22, 2016 8:01 AM by . Berrett.Rice

    Make this LoD calculation NOT boolean

    . Berrett.Rice

      Is there any way to write an equivalent calculation to this:

      {FIXED [State ID]: MAX(IIF([Year]=[Current Year] AND [Grade] = [Current Grade],1,0))}=1


      ... that isn't boolean? I'm running into a million (infuriating) problems because I can't use "if" calculations with boolean expressions.


      The task is that I'm trying to build a matched cohort of students across three years. The expression (in combination with two others) works just fine. However I can't add any logic to it because Tableau won't allow "if" statements with boolean expressions.


      Is there a workaround?