Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i am trying to write an expression to show total sales qty (SalesQuantity) but excluding any Voided transactions. Voids have a (LineType) of V.
I thought it should be something like
Sum({$<LineType=V>}SalesQuantity
But i cannot get it to work..
Can someone help please?
yes it should be enclosed with {}
Sum({$<LineType -= {V}>} SalesQuantity)
Thanks Marcel!
Hi Hopkinsc,
try this:
Sum({$<LineType -= V>}SalesQuantity)
put a dash before an equal sign to exclude all LineType V
regards
Hi Ronald, I have just tried that but it still returns the sales quantity including VOIDS.
Any other ideas?
Maybe i'ts just formatting badly, when I have to exclude something in set analysis I always do it like this :
Sum( {$<[LineType ] -= {V} >} SalesQuantity )
If I don't use { } in the field I don't want to exclude it doesn't work.
Thanks Marcel, but that hasn't worked either....
yes it should be enclosed with {}
Sum({$<LineType -= {V}>} SalesQuantity)
Thanks Marcel!
I think this will work
Sum( {$<[LineType ] = {"*"} - {V}>} SalesQuantity )
Hi Hopkinsc,
that code should work. if the field LineType is two words enclosed it with []
I attached a file that shows exclusion.
Hi, thanks everyone for your replies...
I have managed to get it working by using...
Sum({$<LineType -= {V}>} SalesQuantity)
Thanks again. 🙂