Invoice amount vs payment amount

[Hussein982]

Hi all:

I have an invoice and payment file where I would like to see if we have paid more than the invoice amount. (payment amount > invoice amount).

Appreciate in providing a formula to detect if we paid more than we suppose to. 

Please note that our invoice and payment file does have payments in (-) and these represents credits from suppliers. 

Cheers,

[Qiu]

@Hussein982 
Something like this?

[Hussein982]

Thanks @Qiu. Appreciate the prompt response. One thing is not working for me is the (endi endi).. not quite sure why its not picking up or I am doing something wrong in the formula? 

Let me know once you have a chance please. 

[Qiu]

@Hussein982 
it is "Endif" not "Endi"😂

[Hussein982]

Thank you for being patient 🙂 and thank you so much for the help.

My issue is that when I am writing the second (endif) everything is turning black as you can see below. Please see the below two screenshots for reference.

[Qiu · Accepted solution]

@Hussein982 
Can you kindly check the "PAYMENT_AMOUNT" is of numeric type with a select tool?

[Hussein982]

Thank you! It worked. Appreciate the help. I had to change the type from Vstring to Double.