Forum Discussion

ChrisMcHugh's avatar
ChrisMcHugh
Icon for Helper I rankHelper I
4 years ago

Use an IF on a column containing string value that if it returns true, returns a number

IF(AND(AND(AND(AND(VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS] = "LOADED", (VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS]) <> "PARTIALLY LOADED"), (VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS]) <> "FAILED...
Need Help
ChrisMcHugh's avatar
ChrisMcHugh
Icon for Helper I rankHelper I
4 years ago

Hi Samarth,

 

Yes it is along those lines for definite. However, upon trying your code, this is the error I am getting.

 

 

Is there any way to work around this as I am directly pulling from a column in a dataset