Hi. I cannot use aggregate and non-aggregate fields in the if statement. I want to compare the calculated field with the data source field. What to do? If calculation is like the below statement, here today date and sales goal are calculated fields.
IF [Date] == [Today date] AND [sales] >= [sales goal] then "........." ELSE " ........" END