IF FUNCTION

[Anonymous]

Hi!

This expression returns SALES for only D instances, and i would want both C and D.

= SUM(IF(LEFT([FIELDNAME],1) = 'C','D', (SALES)))

Thanks

[er_mohit]

try this

= SUM(IF(LEFT([FIELDNAME],1) = 'C' or LEFT([FIELDNAME],1)='D', (SALES)))

or

= SUM(IF(LEFT(wildmatch([FIELDNAME],'C','D'),1) , SALES))

[Anonymous]

We can simplify it a little:

SUM(IF(wildmatch([FIELDNAME],'C*','D*'), SALES))

[VishalWaghole]

Hi

Try this

SUM(IF(match(LEFT([FIELDNAME],1),'C','D'), SALES))

or

SUM(IF(wildmatch([FIELDNAME],'C*','D*'), SALES))

Thanks