Forum Discussion

LewisFoulger's avatar
LewisFoulger
Regular Visitor
3 years ago

If statement not pulling correctly

Hi,

I am writing an if statement which will pull the value of another column "Boots Price" where the value of "Lookup" = 0

 

It is not proivding errors but is no providing anything in the spend (which is the new column), please help fix this?

 

As you can see it ppulls from the look up column, but I am wanting to pull from the boots price collumn.

 

Boots Price:

 

 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi LewisFoulger ,

    In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

    Thanks for your efforts & time in advance

     

    Best regards,
    Community Support Team_ Binbin Yu