How to subtract a value only for N rows where N is based from a field

Question

Hello everyone!

I have a flow where I need to do a subtraction but only for a number of rows based on a field value. For example:

On the table above I need subtract "1" (the Target value) from the QTY, but only for the first 4 lines, where the number 4 comes from Diff.

Like this:

Is it possible?

Could anyone help me?

Issue.xlsx

jdunkerley79 · Accepted Answer

Yes, this is possible.

Use a RecordID tool to add a row number

And then a formula to adjust the QTY:

iif([RecordID]<=[Diff],1,0)+[QTY]

Finally, a select to drop the RecordID

atcodedog05 · Accepted Answer

Hi @FabioP ,

Here is a workflow for the task.

Input

Output

Formula

IF [RecordID]<=[Diff] 
THEN [QTY]-[Target] 
ELSE [QTY] ENDIF

Hope this helps : )

If this helps please mark the post as solution.

vizAlter · Accepted Answer

Hi @FabioP — You can solve this through "Tile" tool as well:

Tile tool configuration (hope, no duplicates in your "Code" field):