June 23, 2014 at 10:55 am
=runningvalue gives you a running total down a column.
I can't seem to achieve a running value across columns.
ie I want
2001 2002 2003
apples 5 5 10 15 20 35
Does it matter if the years are individual fields in a table or a matrix group?
Surely there is a simple solution? Thanks
June 23, 2014 at 11:59 pm
Why can't you just do that in your SQL statement? You would probably have to do a lot of
COALESCE(MyColumn1,0) + COALESCE(MyColumn2,0)....
What are you trying to accomplish? can you post a sample (some sample data and a sample of your expected result)?
then at least people can see what you're working with. The data can be completely fake as long as it's representative of your problem.
June 24, 2014 at 2:01 am
Fixed it.
Runningvalue does work across columns or rows in a matrix.
It just seems that you can't do it across columns AND across rows IN THE SAME MATRIX.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply