we have about 20 items in a application and want to calculate the sum of all the these items. the obvious method is to use 'calculate' type and use 'last' function to get the values of the items and '+' operation to sum them all. but there will lead to 2 issues:
1. it's tedious to input 20 'last(xxxx)' string and not easy to read.
2. if one of the 'last' function failed, the entire formula will failed.
so is there any graceful and robust way to do this job?
If there is not a exist way, my suggestion is to add a function like 'grpsum':
example: appsum('app name',[period])
1. it's tedious to input 20 'last(xxxx)' string and not easy to read.
2. if one of the 'last' function failed, the entire formula will failed.
so is there any graceful and robust way to do this job?
If there is not a exist way, my suggestion is to add a function like 'grpsum':
example: appsum('app name',[period])