Hi...I'd like to add a condition to a straight table report to exclude data for certain types of journal category but I am not sure how to do this in the expression.
The exclusion condition I need is
(GLSubLedg.JournalCategory) <> 'Budget' AND (GLSubLedg.JournalCategory) <> 'Payments'
I would really appreciate some assistance with this. Thanks
Thanks. I don't have an amount field on its own but I do have amount cr and amount dr fields so I can add a calculated fields amount cr - amount dr to get an amount field of that works as in some fields there might be amount cr and in others just amount dr. Not sure if that would make a difference in the expression?
Thanks. I will try this and let you know.
To help me understand for future requirements if I needed to change the condition to pick up data for where the journal category is say Sales so rather than exclude, the condition would be journal category = 'Sales' how would I need to change the condition.
I slightly amended the expression and now the expression is ok but the report is still showing lines with the 'Budget' journal category. I don't want these lines on the report
This is the amended expression:
Even with this expression the budget category lines are showing on the report: