Hi, can anyone tell me how i would write an expression to show me waste values but excluding a specific reason please?
My fields are :
There are 2 waste Narrative reasons:
Wastage and WASTAGE
I want to exclude the uppercase WASTE from my results (so i don't want them being added up in the total and i don't want them to display in the chart)
Currently i have a simple expression...
but this show's me both Narratives. I don't want to have a list box for the user to just select Wastage as our average users wouldn't know the difference between the 2 Narratives.
Basically WASTAGE is a system generated reason when the user downloads waste figures using an older program (this program should only be used for FREEZER BREAKDOWNS but now and again some of our customers use it by mistake)
Wastage is the reason generated using the correct program.
you have to apply the if() caluse to every expression in your cahrt. it looks like you have other expressions, most notably the display of the Narrative field which will cause every expression to be evaluated.
The if() calsue is forcing the expression to null but it is being displayed because the row is being displayed.
apply the if() everywhere or remove the other columns.