Multi-row formula with multiple conditions based on value

HarmeetKM

Hi there,

Is it possible to apply a multi row formula on multiple criteria based on value? I want the formula to populate a serial number on a row where the customer name, item description and value are the same. Although for the value, essentially its "where the value is exactly the same but a negative value" then populate the same serial number.

I then want to summarise the dataset so it nets off the positive and negative values for each customer with the same item description. The positive and negative values represent where a product was bought and subsequently returned therefore need to be netted to nil and removed from my dataset

Any help would be much appreciated!

Luke_C

Hi @HarmeetKM 

Take a look at the attached. Prior to using the multirow formula, I created a field that is the absolute value of the amount in order to sort the data. Then I used the multirow formula to fill the serial no if it is null.

New Workflow3.yxmd