Hi Brendan,
would it be possible to implement a calculation somehow that would calculate
result = sum column a – sum column b
Cheers
Yogie
Hi Yogie,
So “sum column a” would be for the entire set of records in that form? I suppose it’s possible at some point. But not before I add multiple calculations per form. That is, I would need to store the result of a calculation on the field object itself which would have to be constantly updated as you were adding, deleting, or updating records in the form. Only then could I add such a type of calculation. I certainly wouldn’t want to compute it live as it would slow down the display of records, especially in multi-column list view.
Thanks!
Brendan
I was going to ask about this, too. I liked that feature in Bento because I could see my net income less expenses/fees.
You could always just add a Calculation field that sums field a and field b and then turn on the Calculation Type for that Calculation field which will display the grand total at the bottom of the records list view.