I'm new to Microsoft Reporting tool and I'm trying to create an expression which looks at a field on the report and returns a value of 0 if the field value is "CASH" and a 1 if the field value is "CARD".
It seems pretty straightforward but the formula never evaluates to 0, it always defaults to 1 even when the paymenttype field is CASH.
Is there a glitch in this program that anyone knows of where I have to do some kind of Cast or something?
My formula is:
Thank you for your help.