Hi experts, I am trying to create a customized field to hold the total amount of invoice after term discount. I have the field set to currency and doesn't store value. Here is the formula that I used. However, the field doesn't pull any result, what did I do wrong?

Can I ask why you need the field in the first place ? And isn't that the same as invoice amount ?

image.png

@raghav Hi, it will not be the same as invoice amount because this is an possible amount that customers may get if they pay early based on the term.

@Summer Sun i tried the same formula as yours sans the handling cost because we do not use that field and i also got a blank field. i used an NVL on the discount amount and it seems to be pulling the calculation

oh nice! thank you so much! i will try that