Multi row formula Issue

[jdevar243]

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

[JosephSerpis]

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? 

[jdevar243]

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 . 

[JosephSerpis]

Hi @jdevar243 if you look at the results on the select tool you see that I resolve that. I revised the workflow slightly noticed I hadn't ticked group by account number so attached workflow. 

[JosephSerpis]

Hi @jdevar243 I revised the formula so I only use one multi-row tool. I've attached the workflow so you should have potentially two ways of approaching this.

[jdevar243]

Thanks @JosephSerpis - 

In the below example - Is there a way to treat account ABC123 ,4/30/20 as a new record and label the flag as true since the date has changed for the same account. 

Since it was datetime i was not able to group by on account number and datetime. 

[JosephSerpis · Accepted solution]

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

[jdevar243]

Amazing @JosephSerpis .

Thank you so much . Will try to implement the same.