Balance Sheet “LIKE”

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 9 years, 7 months ago by 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: http://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

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.