I am trying to check two different fields condition in calculation field and count the number of occurrence of the particular value in the field. "Status List " is one field with values and "Group List" is another field with other values. Now m trying to count occurrence of value "WAMS" if "status list" is "IE " and selected group list is "WAMS"
My syntax is
If ( Status List = "IE" and Group list = "WAMS"; PatternCount ( Group list; "WAMS" ))
Also I tried case statement:
Case ( Status List = "IE" and Group list = "WAMS"; ValueCount ( "WAMS" );0 )
But both are not working. something i am doing wrong.