Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need help getting the sum of a range of variables.
I have 100s of the variables in the following format $(text1),$(text2),$(text3),$(text4),$(text5),$(text6),$(text7),$(text8)
I would like to get the following sums hopefully without having to list all of them. Is there a way to rangesum this variables?
$(text4)+$(text5)+$(text6)
$(text2)+$(text3)
$(text1)+$(text2)+$(text3)+$(text4)+$(text5)+$(text6)+$(text7)+$(text8)
Thank you
AFAIK it's not possible. If it wouldn't be variables else fields there would be possibilities to query the available fields within loops to fetch the relevant information and to concat them with new variables. But in regard of saving time it would be probably faster just to write the whole stuff instead of developing the above mentioned possibility.
Beside this I suggest to rethink your whole approach because your data look like a crosstable and within the most scenarios it's more suitable to transform them to categorize, filter and aggregate the data.
- Marcus