How to get Grand total from a RG (or a data)?

[ericwuu]

I am trying to do something like this

each item’s Qty * each item’s Price :sum

[msgiblin]

Hi there, you’ll need a plugin like RepeatingGroup Tools (bdk) Plugin | Bubble

I provided a similar answer here with a bit more details:

Show RG-Calculation in a normal group?

You’ll need a plugin like RepeatingGroup Tools by BDK to access the values inside the RG: RepeatingGroup Tools (bdk) Plugin | Bubble You drop an element inside the RG, tell it what fields to reference, and what ‘type’ they are. You then drop a parent element inside the page outside of the RG, and tell it what to do with each data type. In your case you would most likely use a :SUM operator on the outside element to sum up the calculations inside the RG.

[saloon-esquiver0t]

Or may be the sum of eachXelement

[ericwuu]

i have my RG list count 22
I couldn’t understand why RGdataA’s column1 list count shows 79 ?!

[msgiblin]

Based on my understanding of your use case, you shouldn’t have a :count in your calculation - try ‘Sum’ instead.

[ericwuu]

because the result $16,815.00 is incorrect.
so, I check the :count
and wondering how come it’s not 22 ?

the list count RGdataA and my RG should be the same, isn’t it?

[msgiblin]

Ahh I understand what you’re showing now, very interesting. Are you using any kind of filter, pagination, etc on the data in the RG?

[ericwuu]

I figured, it’s because my RG is under another RG.

[msgiblin]

So do you have it all working as expected?

[ericwuu]

yes, I figured, probably due to the Extractor name, the plug-in does not work in a nested RG .

thank you for your help!