Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have 3 fields Date, Week and Val
In my table I have an expression sum(Val). When I select Date, it will sum the Val for that Date.
I want to add another expression to sum the Val for all Dates in the Week corresponding to the selected Date.
Any ideas
Ta
Joe
I'm not sure if this will work without Week being a dimension in your chart, but try:
Sum(TOTAL <Week> Value)
If not, try:
Sum({<Date=, Week=P()>} Value)
Hope this helps,
Jason
I'm not sure if this will work without Week being a dimension in your chart, but try:
Sum(TOTAL <Week> Value)
If not, try:
Sum({<Date=, Week=P()>} Value)
Hope this helps,
Jason
Hi Jason
Thanks for that.
First one didn't quite work.
Second one seems to work fine!
But I do seem to be getting a syntax error:
Sum({<Date=, Week=P()>} Val)
Any ideas on what might be causing this, or is it safe to procveed?
Ta
Joe
Safe to go I'd think. The syntax checker was new to v10 and is a little flaky within set analysis although generally one of the best enhancements!