Calculation Enhancements?

Viewing 3 reply threads
  • Author
    Posts
  • January 4, 2014 at 10:56 AM #8600

    Yogie
    Participant

    Hi Brendan,

    would it be possible to implement a calculation somehow that would calculate

    result = sum column a – sum column b

    Cheers
    Yogie

    January 4, 2014 at 2:41 PM #8602

    Brendan
    Keymaster

    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

    January 21, 2015 at 5:19 PM #12761

    Carolyn
    Participant

    I was going to ask about this, too. I liked that feature in Bento because I could see my net income less expenses/fees.

    January 21, 2015 at 7:20 PM #12764

    Brendan
    Keymaster

    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.

Viewing 3 reply threads

You must be logged in to reply to this topic.