PAID AMT is, by definition delayed because people have to do research and request payment before the money arrives. So, it's normal to have NULL in PAID AMT for a while.
Any thoughts? Apparently, I wasn't authoring the conditional statements correctly.
+4Could you share the image again ?
Your image can not be loaded, please send again.
Try to replace NULL with 0 while subtracting.
+1Try to use formula COALESCE(PAID AMT, 0).
COALESCE shows the first value which is not NULL. So when PAID AMT is NULL then the value is 0.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.