S
sft008
Guest
Hello, I am a newbie to this so here goes..
I have a Boolean Yes/No Value in a report.
It print out on the report -1 for yes, 0 for no.
I want to write a line something similar to the following
(Total = (subtotal * .06) if Tax = Yes) else
(Total = subtotal if Tax = No)
Can someone help... I have been pulling my hair out. I tried to operate on the YES/NO with ABS, CInt etc... I get an error. I just need to convert YES/NO to a 1 or a 0 then I can do the rest... Thanks for any help or suggestion.
Thanks
Frank
I have a Boolean Yes/No Value in a report.
It print out on the report -1 for yes, 0 for no.
I want to write a line something similar to the following
(Total = (subtotal * .06) if Tax = Yes) else
(Total = subtotal if Tax = No)
Can someone help... I have been pulling my hair out. I tried to operate on the YES/NO with ABS, CInt etc... I get an error. I just need to convert YES/NO to a 1 or a 0 then I can do the rest... Thanks for any help or suggestion.
Thanks
Frank