hi. i’m trying to sum this column

the database schema is

source i’ve read
Sum item total by category in repeated list

Hello All,
I am new to Appgyver and having some issues trying to sum item amount by category in a repeated list and hope someone could provide some pointers.
I have a list with 3 properties i.e. Category, Icon and Amount for which I need to group by category and compute the total Amount under each category. I have tried using the GROUP formula below to group by category but having problems with grouping formula to compute the total amount by category.
GROUP(data.SBexpenseList, item.Category, …
[SOLVED] SUM_BY_KEY Function questions

Hello Everyone! Can you help me with the SUM_BY_KEY function?
I’m using a local storage and it is called “Local_Full”
I have a field called “Amount” and it is number field.
Let’s say I have four rows of record with 50, 100, 50, 30 in “Amount” field.
I would like to get the sum of all these numbers.
I tried SUM_BY_KEY(data.Local_Full, "Amount) and I’m not getting any return.
Any suggestions?
SUM_BY_KEY is not work

Sum_by_key list

I’m using this formula: SUM_BY_KEY(data.list of products, “total_item”) to add a field from a list, but the value only returns 0, could someone help me.
I’m using this formula: 'R$ ’ + ROUND(data.tb_calc_item.preco * data.tb_calc_item.qtde, 2) , to calculate the total value of the item, through this field I bring the total sum
attached are the screens of how I put my formulas
[TELA2]
[TELA1]
SUM_BY_KEY not working for me

List Totals from a list

I’m trying with no luck to get a total from a list of data. using firebase as my rest api
Add up all entries

how do i sum all values sent from an app variables,
example
1
1
1
1
1
I want to sum all these values example return the total of the sum of entries =5
Read from local database and sum values

I have a local database (resource id: Avoided) with a couple of properties. One of them is called Grams. I can add new entry’s, make lists and edit a single but i have no clue how to go from there. I want to loop through all the records and sum all values with the property “Grams” and put that in a page variable.
(New user alert: I just started two evenings ago with Appgyver…)
solution i’ve tried
SUM(MAP(data.recipeingrDB1, item.rcpingrcostqty))
SUM_BY_KEY(data.recipeingrDB1, “rcpingrcostqty”)
SUM(MAP(data.recipeingrDB1, NUMBER(item.rcpingrcostqty)))
SUM_BY_KEY(MAP(data.recipeingrDB1, {field: NUMBER(item.rcpingrcostqty)}), “rcpingrcostqty”) validation value “rcpingrcostqty” is not equal to “field”
REDUCE(data.recipeingrDB1, item.rcpingrcostqty)
REDUCE_INIT(data.recipeingrDB1, 0, accumulator + item.rcpingrcostqty)

nothing works. it return as null or 0
can anybody help me on this.
namaste…

nobody.?
ok then…
namaste

ok. in desperation i tried to put the formula directly in the input field value (not as a page var) it says “require an inversible formula”. i get it. in needs to work both way. then i try the same but this time in the placeholder value
boom! it works.

then i try to set the formula to a page var (number type), set the placeholder value to said page var. it failed. return as 0.

try the same with text component
works with direct formula input. didn"t work with page var.

conclusion, formula worked, but can"t set to page var with the formula.