Help in formula

[Kinetic_analytics]

Hello Folks:

Good afternoon. How can Ican I write a formula for : If [ABS BAlnce] is the same and Theme ID is also Same - "Do Not Review" Else " Need to Review"

ID	Balance
71	-1666.39
71	-1666.39
71	48712.31
71	48712.31
101	17000000
101	6188000
200	-27000
200	-43579
369	0.04
369	-0.01
369	0.011
57	18599.1
57	-18599.1
57	26849.6
57	-14618
57	290318.7
57	-302550
57	25341.08
57	-25341.1
57	393025.5
57	-393026
57	6702.35
57	-3632.23
57	52457.21
369	-0.01
57	-55527.3
57	5358.35
57	-5533.34
57	116788.5
369	-0.02
57	-116614

Appreciate your help.

Thanks

[ShankerV]

Hi @Kinetic_analytics 

With the help of multirow formula, you can do this.

But you need to sort as the values are spread across the report.

Many thanks

Shanker V

[Kinetic_analytics]

@ShankerV Sorry I did not understand your solution. 

[binuacs]

@Kinetic_analytics What are the expected outputs for the below records?

[BS_THE_ANALYST · Accepted solution]

@Kinetic_analytics 
One way:

[binuacs · Accepted solution]

@Kinetic_analytics Similar to @BS_THE_ANALYST solution

[Kinetic_analytics]

@BS_THE_ANALYST Thank you. 

[Kinetic_analytics]

@binuacs  Thank you .