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

[FabioP]

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?

[jdunkerley79 · Accepted solution]

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 solution]

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 solution]

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

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

[atcodedog05]

Happy to help : ) @FabioP 

Cheers and Happy Analysing : )

[vizAlter]

@FabioP — Thank you!