AnsweredAssumed Answered

Search/Scan Multiple Words in text field and summate

Question asked by AimenYounus on Mar 14, 2014
Latest reply on Mar 18, 2014 by philmodjunk

Title

Search/Scan Multiple Words in text field and summate

Post

     Hello,

     I am facing a problem to sum up result of specific words in a Number field.But i am failing.

     I am using a command :

     If ( Month = "April"  and "May" and "June" ; Sum(US amount) ; " " )

     But still getting no result .Although the US amount field has values.Month is a text field having all months information

     please provide some help.

Outcomes