Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
= SUM(IF(LEFT([FIELDNAME],1) = 'C' or LEFT([FIELDNAME],1)='D', (SALES)))
or
= SUM(IF(LEFT(wildmatch([FIELDNAME],'C','D'),1) , SALES))
We can simplify it a little:
SUM(IF(wildmatch([FIELDNAME],'C*','D*'), SALES))
Hi
Try this
SUM(IF(match(LEFT([FIELDNAME],1),'C','D'), SALES))
or
SUM(IF(wildmatch([FIELDNAME],'C*','D*'), SALES))
Thanks