multi row formula with multiple conditions

[Sifiso]

Hi all

I would like a logic that will change the [Exchange rate] if the four conditions (C1, C2 & C3) are met:

1. Condition one: if [Cost rate] = [Row+1: Cost rate]

and

2. [cost rate] < 0

And

3. Condition two: if [Batch number] = [Row+1: Batch number]

and

4. Condition three: if [ID] = [Row+1: ID]

desired outcome

[Jon-Knepper]

Maybe something like this would work, iif([Cost rate] =[Row+1: Cost rate] && [Batch number] = [Row+1: Batch number] && [ID] = [Row+1: ID] && [cost rate] < 0,[Exchange rate](INSERT LOGIC FOR CHANGE),[Exchange rate]).  This can be accomplished using the multi row tool.  I am away from my designer right now other wise I would run a test.  I also noticed that there is a space behind the comma on some of your number values.  Is this true or is that just a typo?  Asking because it will affect your logic.

[IraWatt]

Hey @Sifiso, I assume row one C1 should be positive and condition 4 should be  [ID] = [Row-1: ID] for this to get the desired output. Also should the ',' in column one be '.'.? Could you also post your example data in a format which can be copied 

[IraWatt · Accepted solution]

@Sifiso here's one way to do it:

Any questions or issues please ask :)
HTH!
Ira

[binuacs]

@Sifiso In order to get the desired result I adjusted the formula