Report Model Expression

I'm new to Report Model and trying to create a new expression field with IF condition on related Role's attribute when i do this it gives error "The arguments to the following function are not valid: = (Equal to)" but if put direct Entity's column it works fine.. heres the expression

IF(Activity Type List Value Display Name = "Sick Day", 1, 0)

"Activity Type" is the Role(1--*) in Employee Table, and i'm adding this expression in the Employee Table

are there any sample models that i can download with some complex filters/expressions etc?

regards

faraz

any idea?|||It seems microsoft people are not interested in Report Model :)|||

Sorry for the delay in responding. Based on the cardinality of the role (1-*), it sounds like you are trying to compare a *set* of activity type display names to a single value. The equals operator cannot do this. Instead, wrap the field reference in the COUNT aggregate function, then double-click to expand the field reference and add a filter to count only the activity types where the display name is "Sick Day". You can then use your IF function to return a result based on the number of activity types that meet this condition.

Hope this helps!