How to filter out Project_No '9000098' from Project_Number

[bhaveshp90]

Hello,

I want to have all the Project Numbers except '9000098' from the Project_Number column.

How can  I do that? 

thanks

[vishsaggi]

OR

= Sum(IF(Project_Number <> '9000098', Measure))

[bhaveshp90]

Yes, It worked out. thank you

[bhaveshp90]

thank you Sunny. I have used this expression and it worked out.

(Sum({<Project_Number -= {'9000098'}>}GMP_Gross_Profit_USD)

/

Sum({<Project_Number -= {'9000098'}>}GMP_Sales_USD))*100

[sunny_talwar]

Awesome