Condition on group field name

[agni_gold]

Hi Friends,

I have one cyclic group in which I have created one calculated dimension like

=CalendarMonthName& - &%Year        and Label its as Month

Now when I am applying condition on my cyclic group which is <cyclYM

it is not working

=if(GetCurrentField("<cyclYM")='=CalendarMonthName& - &%Year ',1,0)

[Anil_Babu_Samineni]

Use, Something like below in synthetically

I would ask you create in script

CalendarMonthName& - &%Year as FieldName

Try this?

=if(GetCurrentField([cyclYM]) = FieldName, 1,0)

[agni_gold]

Thanks, but in script level, it is not supposed to done .

Any alternative in front end ?

[Anil_Babu_Samineni]

My recommend always in Back end only. If you want to forcibly to do in front end. I would ask to share sample application that demonstrates the issue?

[agni_gold]

here it is

[Anil_Babu_Samineni]

Can i know the reason why you don't want to do in Script because i felt it is very bad in Front end. Even you are using simple Year and Month only why can't club or create composite key and uses rather than complex. Still you need i recommend him mrkachhiaimp‌

[agni_gold]

This is just a mock application , but in my actual application Year and Month fields are used from different tables.

[agni_gold]

swuehl‌  can it be possible?

[swuehl · Accepted solution]

The single quotes in your calculated dimension interfere with your expression to check current dimension, for example, you can try to replace them:

=if(Replace(GetCurrentField("<cyclYM"),chr(39),'|')='=YearOrg&| - |&%Month',1,0)

[agni_gold]

You are so awesome man great !

Thanks