Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I created several variables and I am using them in a cyclic group. Now I want to used the "friendly name" of the variable on my chart title (depending on the variable selected on my graphic).
How is that possible?
Thanks
LC
You can use the getcurrentfield function to get the name of the active field in the cyclic group. Something like
if(getcurrentfield(MyGroup)='ValueA','Description A',
if(getcurrentfield(MyGroup)='ValueB','Description B',
if(getcurrentfield(MyGroup)='ValueC','Description C')))
I´m using something like this:
=if(GetCurrentField(Mycyclicgroupname) = 'vABC', 'Peter',
if(GetCurrentField(Mycyclicgroupname) = 'vDEF', 'Anne'))
It seems like if the cyclic group name isn´t recognized (red underline).