I'm trying to create a conditional sum but I'm having difficulty with the calculation.

I have an Administration layout that gives a company overview by a variety of calculation fields.

I have work orders recurring by month for multiple route men. Each month has a different grand total value due to the following conditions: number of tickets, number of call backs and number of one timers.

I want to sum the total ticket value of the current month, omit the call backs and one timers and return the result to a portal field.

I know I can write a script to sort the records omitting the conditionals to return a value, but I'd rather use a calculation so that my other calculations are not skewed by the sort.

Your input would be much appreciated.

Thanks

I have a way to do this, but it is not fun.

There are two steps:

1. Create a calculation field that says: if ( isblank (Tickets) ; "" ; "1")

This is assuming you have separate fields for tickets, call backs and one timers. If that is not the case and you use a dropdown for these Types, just use "if ( type = "tickets" ; "1" ; "" ) where "type" is the name of the field with the dropdown.

2. Then create at summary field that counts the calculation field above.

Repeat the steps above for call backs and one timers

Then, put the summary fields in the footer.

I hide the calculation fields behind the field they are calculating.

I hope that helps.

1. Create a calculation field that says: if ( isblank (Tickets) ; "" ; "1")

Hmm, "isblank" eh? Is that in the Santa Monica version of FileMaker?

Assuming you mean isempty, you could simplify that to:

not isempty(Tickets)

LOL!

I am in Malibu a few miles away and it is not in my version

:woohoo: