How can we emulate Excel calculations with a Matrix Field?

  • Profile Image
    Asked on September 23, 2016 at 02:19 PM

    As far as the expense report form, we need to have the matrix calculate how the attached excel sheet performs.

  • Profile Image
    Answered on September 23, 2016 at 03:39 PM

    Hello, although the sheet you provided on your screenshot may look straight forward, we still need you to better explain to us what you want to happen with your calculations.

    Like, how will the calculations be done, how do you compute for each cell/row/column, and so on.

    Bottomline, the more detailed your explanations would be, the better we can assist you in figuring out how to achieve them. Hoping to hear from you soon.