Cyclic Group variable not working

[#1]

Hi everyone,

I am trying to use getcurrentfield= in order to use a cyclic group as a chart expression, here are the Dimensions:

and is the expression (note that I am not using multiple expressions, just trying to explain what's going on):

I'm just curious as to why the EthFlag expression works but when I use a variable as a cyclic group, it does not. I have used text boxes to prove that the vDemoPick Variable works, and it shows up correctly when I cycle through the demographics, but when I put in into an expression it stops working.

Thanks guys!

Joe

[sunny_talwar · Accepted solution]

Can you try this:

Sum($(=GetCurrentField(Demographics)))/Sum(TOTAL <Year>$(=GetCurrentField(Demographics)))

[#3]

Thank you! I never understand why some syntax works better than others in certain situations... Could you possibly elaborate?

Thanks again!!

Joe

[HirisH_V7]

Hi,

check changing your variable like this,

vDemopick=GetFieldSelections(Demographics)

HTH,

Hirish

[maxgro]

maybe you have some space in the fields of the group

try with

='[' & GetCurrentField([Demographics]) & ']'