2 Replies Latest reply on Apr 5, 2013 3:32 AM by yulia.khazanova

    Can't compare integer and string values

    yulia.khazanova

      Hi!

       

      I need to filter my data and make sure all three seasons (1, 2, 3) are involved.

      For filtering the data I use the following formula:

       

      MAX(IIF([season]="1",1,0))+

      MAX(IIF([season]="2",1,0))+

      MAX(IIF([season]="3",1,0))=3

       

      However, I receive an error message: "Can't compare integer and string values".  How can fix the problem?

       

      Thanks!