Help in Balance Formula

[Kinetic_analytics]

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

[ShankerV]

Hi @Kinetic_analytics 

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

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Kinetic_analytics 

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

[Kinetic_analytics]

@ShankerV Thank you. Appreciate your help.