Help in Balance Formula

Hello Analytics Fols:

Good morning. I am struggling to form a formula to balance.

I want to remove from the list if the balance is done with a positive number by the negative exact same number. How can I achieve that?

Appreciate your help.

Thanks

Workflow

Accepted answers

Please find the use case for your scenario.

In the below use case, the positive and the negative numbers are equal and are marked as 1 in Temp column.

IF [Balance]=([Row-1:Balance]*-1) or [Balance]=([Row+1:Balance]*-1)
THEN 1
ELSE null()
ENDIF

Then the filter,

So the output is excluded with those values.

Many thanks

Shanker V

It can be achieved with the help of Multirow formula tool and then filtering the values which are equal.

Many thanks

Shanker V

Please find the use case for your scenario.

In the below use case, the positive and the negative numbers are equal and are marked as 1 in Temp column.

IF [Balance]=([Row-1:Balance]*-1) or [Balance]=([Row+1:Balance]*-1)
THEN 1
ELSE null()
ENDIF

Then the filter,

So the output is excluded with those values.

Many thanks

Shanker V

@ShankerV Thank you. Appreciate your help.