Hi all I would like a logic that will change the [Exchange rate] if the four conditions (C1, C2 & C3) are met: * Condition one: if [Cost rate] = [Row+1: Cost rate] and * [cost rate] < 0 And * Condition two: if [Batch number] = [Row+1: Batch number] and * Condition three: if [ID] = [Row+1: ID] desired outcome

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:

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

and

[cost rate] < 0

And

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

and

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

desired outcome

Preparation

Accepted answers

IraWatt

@Sifiso here's one way to do it:

Any questions or issues please ask
HTH!
Ira

Workflow0506.yxmd

All comments

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

@Sifiso here's one way to do it:

Any questions or issues please ask
HTH!
Ira

Workflow0506.yxmd

binu_acs

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

Multi_Row_06_06.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335