Balance Sheet “LIKE”

  • Hi I found your plugin very helpful, thank you for this. Could you please guide me how can i achieve a BALANCE SHEET like using list field. As of now i am having problem on how will i calculate the running balance as i need to add and subtract ‘debit’ and ‘credit’ columns.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author ovann86

    (@ovann86)

    Hey,

    Sorry for not replying sooner – for some reason I’m not getting notifications.

    Can you give an example of what you’re trying to achieve – if it’s hard to communicate, perhaps an Excel document?

    Do you mean something like below

    Item…Credit…Debit…Total
    xxx1……100…….0…..100
    xxx2……..0……50…..-50
    …………………….—-
    ………………………50

    • This reply was modified 8 years, 4 months ago by ovann86.
    Thread Starter cars.wahab

    (@carswahab)

    Hi, yes exactly!

    Plugin Author ovann86

    (@ovann86)

    Hey,

    Sorry for the delayed response – this dropped of the radar.

    I had a go at setting up what we talked about and saw that my code was removing the minus/negative symbol. So the -50 was turning into 50.

    I’ll release an update shortly that’ll fix this.

    Here’s an example of what I think we were talking about:

    Form: https://demo.itsupportguides.com/list-field-number-format-for-gravity-forms/balance-sheet-example

    Screen shot: demo.itsupportguides.com/downloads/Balance sheet example.png

    You can download a copy of this form here: demo.itsupportguides.com/downloads/Balance sheet example.json

    Thread Starter cars.wahab

    (@carswahab)

    HI SORRY FOR LATE RESPONSE, but on 4th column which is total, instead of showing the value being deducted or added, is it possible of showing the total itself on each?

    Plugin Author ovann86

    (@ovann86)

    Do you mean like a ‘running total’?

    Item…Credit…Debit…Total
    xxx1……100…….0…..100
    xxx2……..0……20……80

    Initial thought is no, but I’ll give it a little more thought to see how it may be possible.

    The problem is the whole thing is built around doing math horizontally – but to do a running total it would need to take the value from the previous “total” and then do the math to give the new “total” … sounds tricky and problematic.

    Thread Starter cars.wahab

    (@carswahab)

    yes please, calculate it vertically ??

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Balance Sheet “LIKE”’ is closed to new replies.