Set Analysis Query 2

[anthony_kinsell]

Hi,

I'm trying to get the total for my 'DevBudgetAmount' field for the "Rolling" budget scenario no matter what date selection is made - I've tried the below but it's not correct - can anyone point me in teh right direction?

sum({1}{$<Scenario={"Rolling"}>}DevBudgetAmount*-1)

[jerem1234]

Maybe:

sum({<Scenario={"Rolling"}, Date=>}DevBudgetAmount*-1)

where Date is your Date field.

[chiru_thota]

sum({<Scenario={"Rolling"}>} TOTAL <Dimension1,Dimension2>DevBudgetAmount*-1)

Don't mention Date column in TOTAL <>.

This will sum up the data irrespective of Date.

[anthony_kinsell]

This sums the data but doesn't take into account different dimensions

[anthony_kinsell]

Anyone else got a suggestion?

[jerem1234 · Accepted solution]

Maybe:

sum({1<Scenario={"Rolling"}>}DevBudgetAmount*-1)

If this doesn't work, can you explain why it isn't working, what the behavior is when you use this?

Even better, post a sample app demonstrating the problem so people may help you faster.

Hope this helps!

[anthony_kinsell]

That's is

Thank you