How can I test the state of multiple fields and come up with a true/false or 1/0?

My dumb dumb calculation looks like this:

Case (

Get (CurrentDate) ≥ date_invoice_by_field, [color:red]and

approve_field = "Approved", [color:red]and

not IsEmpty(_mf_invoice); 1; 0

)

Basically I'm trying to test to see if an Assignment is available to be invoiced.

Thanks for the help!

Get rid of the commas. Also, you dont really need the Case statement. You can just have it with the logical test. It all criteria is met then it will result in 1.

Ojy! I did not have commas in actual calculation, but sense that was your only correction, it made me think. Took a closer look at the calculation and... I did not have checked the "Do not store calculation" storage option.

So obviously it did not work properly.

Thanks for helping me work that out!