5 Replies Latest reply on Jun 6, 2017 2:31 PM by Joe Oppelt

    Can't compare boolean and string values in IF Statement

    Jen Miller

      hi - I cannot get the below calculation to work. Any idea on how to fix it?


      Count (if [Flag1] = 'True' and [Flag2] = 'False' then [Account ID] end)


      I get error for both Flag1 and Flag 2 stating "Can't compare boolean and string values".

      Account ID is dimension field that I want to count on based on flag conditions.


      Let me know what I am doing wrong here?