Rob Fox Posted January 7, 2019 Share Posted January 7, 2019 Hello All- I'm sure I'm missing the obvious, but I can't get the following IF Statement to work correctly in one of my calculated columns: If([PASSON]="Z",If(([Weight]=1),([uNIX QTY SHIPPD] * [unit Sell Price]) - [PASSON AMT],0),If(([Weight]=1),[uNIX QTY SHIPPD] * [unit Sell Price],0)) Regardless if "Z" is in the [PASSON] column, it defaults to the "else" portion of the statement. The value of the [PASSON] Colum is a string and I have tried both upper and lower case. THoughts Thanks!!! Link to comment Share on other sites More sharing options...
Gaia Paolini Posted January 8, 2019 Share Posted January 8, 2019 Hi can you please attach a sample dxp with sample data It is not possible to work out the problem without the actual data. Thanks Gaia Link to comment Share on other sites More sharing options...
James Watts Posted January 24, 2019 Share Posted January 24, 2019 Have you tried checking for any non-display characters in the column Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now