Hi TF people,
I’m on the trial version of TF and attempting to set up an invoice system to replace that which I was using in filemaker.
I would like to use a Total that simply calculates the value of multiple line totals, however, if any of these are not filled in (which will usually be the case), the calculation fails.
I can make it work if I set a default of 0 but I’d rather have unused fields left blank if you see what I mean.
I can’t currently see a way of doing this and I really would rather avoid scripting if at all possible.
Is there a simple solution that I’m missing, I’m not the brightest tool in the picnic box?
TIA
Attachments:
You must be
logged in to view attached files.
Instead of separate fields, you could use a table field for your entries. There is an option to show the total at the bottom.
I don’t use the calculation field that often. But changing the formula to this might help:
IFNOTEMPTY(LINE TOTAL 1;LINE TOTAL 1;0) + IFNOTEMPTY(LINE TOTAL 2;LINE TOTAL 2;0) + IFNOTEMPTY(LINE TOTAL 3;LINE TOTAL 3;0) + ......
Another option would be to use a javascript function for the calculation.
Thanks for the quick reply Daniel, unfortunately, the formula doesn’t seem to do anything and I get nothing in the Total calc field at all so I’m probably doing something wrong but I can’t figure out what.
I find the table incredibly difficult to deal with as I would want to turn off things like row and column titles which it doesn’t seem to allow.
Sigh, I guess I’d best attempt to deal with some javascript, er, any chance you could point me in the right direction?
Belay that – I got your script working!
Not sure how to explain but I had to double click the ‘line totalx’ elements to place them in the formula rather than typing out.
Attached image possibly shows this.
Anyway, I think I can work with this so much appreciated – thanking you kindly Daniel.
Attachments:
You must be
logged in to view attached files.
Great that you got it working, Yan. Thank you for your feedback.
.
