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?
Tried SUM(Amount)?
I’m not understanding well the exact context / data structure so that’s my suggestion so far.
SUM didn’t work
Below is my DB structure. I have a on-device storage with only two fields ID and Amount. I would like to be able to sum all the amounts in Amount. I have added the resource as a full collection and single record on the page where I’m trying to show the sum amount.
SUM(MAP(data.Local_Full, NUMBER(item.Amount)))
This worked! Thanks @Fred_Kuzyk for telling me to use SUM
Great, but why do you need to use the NUMBER formula, if the “amount” is already a number type?
I was curious about that, too. For some Amount values, I had decimal numbers such as 15.50 and 5.50. Is it because of the decimal numbers and I used the FORMAT_LOCALIZED_DECIMAL with 2 decimal points?
That’s still a number. Maybe that’s because of the local storage. I’m not familiar with that.
