Question:
Hi,
If CHAR1 = 'X', Then NetAmount = 'NetAmount' * -1. Is my requirement.
But I can not see a way to input the 'X' into the condition being a non-numaric in My BEx.
In the 'New Formula' option I was trying the following:
I could have the formula as
(VAR_CHAR1 == 0)*(Netamount*-1)
But not able to Check the value 'X' in the condition.. Do any one can help me please in finushing this... ( I can not chane the back-end, as this is specific to this report only. Please suggest Idea other than creating a duplicate variable in the backend.
Many thanks for your time.
Jumper.
Answer:
Hi,
if you create a restricted KF where CHAR1 is restricted to 'X' and for KF 'NetAmount' you get these values. Then hide this in the report and create a Formule where you use the restricted KF and multiply by -1
Kind regards
/martin
Answer:
Understood the trick Martin.
Thanks.
I will Implement and will come back on Monday.
Have a Nice weekend.
Best Regards,
Quer123
Answer:
Thanks Martin. It worked out well.
Best Regards,
Jumper.