Wildcard

[GregRyder]

Here is my formula 

Sum(if((TCODE='PU' and [Supplier Code]='S*') ,AMOUNT))

I am trying to get the sum AMOUNT of all [Supplier Code] beginning with the letter 'S' and the * symbol doesn't work

[hic · Accepted solution]

Sum({<TCODE={'PU'},[Supplier Code]={"S*"}>} AMOUNT)

[marcus_sommer · Accepted solution]

Try it in this way:

Sum({< TCODE = {'PU'}, [Supplier Code] = {"S*"}>} AMOUNT))

- Marcus

[GregRyder]

Thanks that worked perfectly