set analysis with GetFieldSelections

[ilanbaruch]

Hi All,

i want to create an expression with set analysis based on another field / dimension selection?

any ideas ?

tried it like this:

sum({$<Office={GetFieldSelections(OFFICE_BUDGET)}> } amount) 

[sunny_talwar]

Try this instead:

Sum({$<Office = P(OFFICE_BUDGET)>} amount)

[sunny_talwar]

Or this if you really want to use GetFieldSelections

Sum({$<Office = {$(=Chr(39) & GetFieldSelections(OFFICE_BUDGET,Chr(39) & ',' & Chr(39)) & Chr(39))}>} amount)

[MarcoWedel · Accepted solution]

Hi,

maybe another solution could be:

Sum({$<Office=OFFICE_BUDGET>} amount) 

or

Sum({$<Office=$::OFFICE_BUDGET>} amount) 

to avoid an "error in expression":

hope this helps

regards

Marco

[ilanbaruch]

it helps,thank you!

[Anonymous]

Hi ilan,

     It is working fine, but what is the actual usage of $::. Thanks in advance...