4 Replies Latest reply on Feb 8, 2019 9:57 AM by Vaishnavi krishnan

    Can't logically 'and' bolean and integer values - formula help

    Lucia David

      Hello,

       

      I am trying to create the following calculation:

       

       

      IF ([Assessment Name] = [Parameters].[Assessment Name]

      AND

      COUNTD ([Total Number of Extensions]>0)) THEN 1 ELSE 0

      END

       

       

      However it keeps on displaying the error above, I have tried writing it a number of ways and looked on the community but had no luck.

       

      Is anyone able to help please?

       

      Thanks