Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have 2 issues.
I am attaching the excel and qvw. When ever currency is USD I want Price 1 column to be displayed. If it's something other than USD then I want Price 2 column
If Status is Post then I want value to be positive else value to be negative displayed in brackets
Kindly help
Thanks
Please check the attached qvw
Hi
Thanks for your help. I was able to do the first one. But for brackets, I am having brackets in all the values instead of the condition, please let me know where I went wrong.
This is my expression
=if(Status = 'Held', NOTIONAL, num(NOTIONAL*-1,'00; (00)')). I am getting all the values in brackets
Hi
Thanks for your help. I was able to do the first one. But for brackets, I am having brackets in all the values instead of the condition, please let me know where I went wrong.
This is my expression
=if(Status = 'Held', NOTIONAL, num(NOTIONAL*-1,'00; (00)')). I am getting all the values in brackets
Thanks a lot. I fixed both the issues with the lead given by you.