Forum Discussion
Custom Columns
I'm tring to create a custom column which uses sum(Sales) but want to filter on another column call type where it shows everything EXCEPT Types that equal "JC" or "JD". Tried the following syntax bu...
Hi Dale
I want it to get the NET figure for Sales but exclude TYPE of "JC" or "JD". I want those types to return a value of 0
Hi magutter,
You can try it like this:
if [Sales] > 0 and [Type] <> "JC" and [Type] <> "JD"
then [Net Amount]
else 0
Best Regards,
Dale