Error in Oracle BI expression

Question

I am trying to check if the field is 0 or null and if so, the remaining amount will be equal the invoice amount.

This error appears and I searched for it but I found nothing!

Here is the code:

IF (G_Invoice.Amount_Paid = 0 OR G_Invoice.Amount_Paid is null )

then

Remaining_Amount := G_Invoice.Invoice_Amount

else

G_Invoice.Invoice_Amount-G_Invoice.Amount_Paid

end if;

Answer 1

If the measure is being calculated in Oracle BI, the LSQL code should be:

Remaining_Amount - ifnull(G_Invoice.Amount_Paid,0)