How to set a dimension value in an expression.

[#1]

I have a gauge that show the actual income as a percent of budgeted income. This should display the result for the user's selection of period and department. However I always want to show Income. So if the user has selected 'Fin Stmt Section' to be 'Expenses', I want the expression to overide this setting. ie set 'Fin Stmt Section' to be 'Income'.

The following doesn't really work: if("Fin Stmt Section" = 'Income', Sum(Actual$)/Sum (Budget$),0)

as it gives the correct result if the user selected 'income' otherwise is shows zero.

Thanks for your help..

Derek

[#2 · Accepted solution]

Hi Derek,

If you got an field name with spaces in it, use the [ ] brackets

try using Set analysis:

Sum({$ <[Fin Stmt Section]={"Income"}>} Actual$) / Sum({$ <[Fin Stmt Section]={"Income"}>} Budget$)
This should do the trick

[#3]

Thanks Rey-man - that worked and I've learned something new.