Column Hiding and conditional sign value

[#1]

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

[NareshGuntur]

Please check the attached qvw

[#3]

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

[#4]

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

[#5]

Thanks a lot. I fixed both the issues with the lead given by you.