Calculation help needed!

[minglebrot]

I am trying to figure out how to make a calculation field....

I start with

Balance = Job::Price - Invoices::Amount

That gets me close but I need to figure out how to only include Invoices::Amount where Invoices::Paid Date is not null....

I'm sure this is possible... Can anyone help?

[IdealData]

Use the CASE function.

Here's a clue...

Invoices::Paid Date ≠ ""

[minglebrot]

Hey thanks, I'll look into that...

[minglebrot]

This is what I came up with -- but following this tip but it still produces the same result. I even tried making a calculated Paid? field in invoices to simplify matters but it still doesn't work. Any suggestions?

Price Agreed Upon - Sum (

Case(

Invoices::Paid? = "Yes" ; Invoices::Amount;

Invoices::Paid? = "No"; 0;

0

)

)