AnsweredAssumed Answered

multiple condition check in IF statement in calculation field

Question asked by anjani on Jul 27, 2017
Latest reply on Aug 3, 2017 by philmodjunk

Hi,

 

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.

Outcomes