Formula to check against same value dataset

Question

Hi

I need to create a formula for the below to replicate column K & L.

Column K looking at invoice currencies and if they match to say "correct" else "check"

Column L looking at invoice values and if they match to state "correct" else "check"

thank you all for your help! :-)

DataNath · Accepted Answer

@Metadata21 you can just create a couple of new fields within the Formula tool, using expressions like the following. I've just used mock data so you'll obviously need to replace Curr1/Curr2/Amount/Amount1 with your fields:

binu_acs · Accepted Answer

@Metadata21 One way of doing this