Table set value based on criteria of previous rows in modern designer

asked on October 14, 2024

Hey guys,

I have a table of data where there are values (Current Owed) pulled in from a lookup and the customer will be choosing which items to pay for.

If they tick yes, it will set another field's value (Paying today) to that lookup's value and if it's no (unticked), it will be 0. Which is simple enough to implement.

The troublesome part now is that if we have an item number that is already being paid for in a previous row, we want following paying amounts that the row has the same item id to be 0.

So, in the example, if someone selected item 1 in 5 rows, only the first instance of item 1 would have the payment amount pulled in from the lookup.

Would what I am trying to achieve, be possible with using the in-built formulas and what would be the easiest method to accomplish this?

Thanks

0 0

replied on October 16, 2024

What you're wanting is it basically saying "if this is the first row that shows value x in field y, do this calculation, otherwise leave it blank or zero".

Unfortunately, I'm not certain how you would go about something like this with the formulas available.

In Excel, if you had a column of various item numbers, and a column next to it of row numbers, you could add a third column that uses the MINIFS formula to get the lowest row number for the current row's item number - then it's just a matter of comparing if the current row number matches the result of the MINIFS formula for that row. Looks something like this:

Unfortunately, the help documentation doesn't list a MINIFS (or MINIF) formula or anything similar to it.

0 0

Question

Question

Table set value based on criteria of previous rows in modern designer

Replies

Sign in to reply to this post.