Hi, I don't understand this. I think I've been trying everything at this point, but I guess I did not.
I have multiple repeats, which all creates a value for Example costs. That could be in a grocery store, where we can choose fruits and fish. Under that we have a level with types, that could be bananas, apples, salmon etc.
All have a value of the weight. I want to calculate the total weight of all the groceries. I can get this to work with connect, but not in web.
This seems to work in connect:
coalesce(sum(${weight_1}), 0) + coalesce(sum(${weight_2}), 0)+ coalesce(sum(${weight_3}), 0)
But the field is blanc in web.
I then tried to add the raw calculations in 3 fields like:
sum(${weight_1})
sum(${weight_2})
sum(${weight_3})
And added to a more simple version:
sum(${weight_1})+sum(${weight_2})+sum(${weight_3})
That actually seemed to work, when I did the first testing also in web, but when I hided and added more calculations to it, or maybe it was since I used multiple calcualtions in the same category, it again didn't calculated the sum.
Any idea how to create this?
Thanks
