Return to FileMaker.com
Another question about Case function......
I have understood the basic about Case function.
However, I still have another question.
Available field: Balance, Invoice, and Vender#1
Here is the calculation that I wanna do:
When Invoice contains a letter U and Vender#1 = ABC, then Balance = 0
I have no clue how to write a formula with "contains"????
Case (PatternCount ( Invoice ; "U" ) and Vendor#1 = "ABC" ; Balance )
Retrieving data ...