Search/Scan Multiple Words in text field and summate
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