I have a table with the following two number fields:
feeamt
expenseamt
and a calculated field:
cbillamt = return (feeamt + expenseamt)
Now, I want to create an aggregate field: sumBillamt to be the sum of cbillamt.
Since cbillamt was not in the list of fields, I made it a stored calculation and created the aggregation based on that stored calc field.
The calculated field is correct, however, the amount returned in the aggregate field is not correct.
Am I going about this in the correct way?
confirmed.
After a search,
total seems to equal only first record total.
Ater clicking into second record, aggregate updates corrrectly.
Will pass to dev team.
Thanks.
Has this been fixed? If so, what version. I am trying to sum a stored calc field and it is not working.
That must be! Or else I have BIG problem with my customers!
Can you describe what is going wrong??
I found my problem.
I created the caculation field first in Servoy (because I wanted to try it unstored first), then created a database field with the same name in MySQL. When I went back to Servoy, the calc field was already clicked as stored. The database field was not being updated correctly, even though the stored box was checked in Servoy. I deleted the calc field and recreated the stored calc using the dropdown and it worked just fine after that.
Sorry for any confusion…
Thanks,
Jason