SUM Field Calculation

[Hemen Babla]

Hi,

 

I am trying to get the sum() of field base on two condition.

 

Attached is my calculation : If ( Invoice Entries::INVPaid=0 and Invoice Entries::Age of record<-30;Sum ( Invoice Entries::Inv Amount );0 )

 

Please let  me know if i am making any mistake.

[Fitch]

I'm guessing you're defining this calculation in the context of a parent record (Client? Invoice?) that has multiple related Invoice Entries records.

You'll need to either define a new calculated field in Invoice Entries:

Case( INVPaid = 0 and Age of record < -30; Inv Amount )

// (age less than -30 is that right?)

... and then get the Sum() of this new field, or;

... create a new relationship to Invoice Entries that includes your INVPaid and Age conditions, and base your Sum() on that.

Or get FileMaker 12 and use ExecuteSQL.

Welcome to FMForums!

[Hemen Babla]

Hi, thank you very much it work for me. sorry was out so couldnt reply you.

 

Also can you help me to intregate Barocode to my database.

 

I have an inventory database where i do all the in and out. my client requirement is that during the time to stock receive he will just scan by the serial number of that product to save in the inventory database.

 

can you help me?