Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to get the current label from the cyclic expression.
I have a table with 3 columns, in column 1 is use a cyclic expression.
I want column 3 to react (different formula) on the chosen expression from column 1.
is this possible with getcurrentfield (cyclic expression is not a dim-group) or is there a other function to use?
Hi Jochem, you can, however is not as ellegant as using the getcurrentfield function with group expression. For instance, let's say you have a group of expression that contain a expression labeled as One and another expression labeled as Two, then in you third expression which is not part of the group, you could use something like:
=if(len([One]),sum(1),if(len([Two]),sum(2)))
Regards
Hi Jochem, you can, however is not as ellegant as using the getcurrentfield function with group expression. For instance, let's say you have a group of expression that contain a expression labeled as One and another expression labeled as Two, then in you third expression which is not part of the group, you could use something like:
=if(len([One]),sum(1),if(len([Two]),sum(2)))
Regards
Thanx Ivan, thats the solution!