Multi row formula Issue

Hi

i am working on one scenario and not getting the desired solution . Can someone please suggest me other alternative solution.

I need to flag an account in the same date when ever there is change in the amount . I did use multi row formula

Example:

Account_no Datetime Amount flag

ABC123 4/29/20 8:00 12 TRUE

ABC123 4/29/20 9:00 12 TRUE

ABC123 4/29/20 13:00 17 FALSE

ABC 123 4/30/20 8:00 19 TRUE

ABC123 4/30/20 13:00 20 FALSE

Developer

Developer Tools

Expression

Accepted answers

Hi @jdevar243 revised the workflow and produce the output you suggested.

Multirow_290420_V2.yxmd

All comments

Hi @jdevar243 I mocked up a workflow I was unsure exactly what you wanted so came up with two approaches. Let me know what you think?

Multirow_290420.yxmd

Thanks @JosephSerpis .

Is there a way to default the first row as true ? For the below screenshot i do not want to flag the records if there is no change at all. In the below example there is no change in BCD123 account amount value but still the flag is labeled true and false .

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703