1 of 1 people found this helpful
Have you tried doing something like this?
IF [sales figure] > 0
If this doesn't get what you are expecting try posting a packaged workbook.
Thanks Grayson, i'm getting error messages with that but it looks to be the right direction so I expect i'm entering it wrongly. I'll keep trying.
You will need to do the SUM() of the sales figure or else you will get the aggregate non aggregate error. Let me know if that fixes your issue.
Thanks Grayson, I was using the SUM figure. I'll try again tomorrow, end of the day for me now.