when if and aggr(count) are used together....!

[#1]

Hey guys

This Expression Worked fine:

Aggr(Count({$<[Field_Name1]={"*New*", "*Work*"}>}[Field_ID]),[Field_Priority])

but why would it not work when I put it in an if statement. like this:

If([Field_Create_Date]<= vToDate, Aggr(Count({$<[Field_Name1]={"*New*", "*Work*"}>}[Field_ID]),[Field_Priority]))

where vToDate is a variable created by me. vToDate = Date(Today(),'MM/DD/YYYY')

There could be two cases where it had failed. The 'if' statement or the variable definition. Can any one of you guys help me finding out where i went wrong..........

many thanks guys

[pover · Accepted solution]

Since there is a Field_Create_Date for every Field_Priority try

Aggr(Count({$<[Field_Name1]={"*New*", "*Work*"}>} If([Field_Create_Date]<= vToDate, [Field_ID])),[Field_Priority])

Regards.

[#3]

Works like a charm. Thank you very much!