Hi every one , Good Morning !
Today I need help in finding the field name of the expression. I created a
1) Bar Chart with
2) Dimension : a) Region
b) =if(Month1=2,'Feb',If(Month1=3,'Mar',if(Month1=4,'Apr',if(Month1=5,'May','Jun')))) [ Label = Month ]
both the dimension is grouped together and named as Group1.
3) Expression : Sum(Sales)
To get the result : I used =if(GetCurrentField([Group1])='Region','A',if(GetCurrentField([Group1])='Month1','B','C'))
but i did the result B .
I think you need Concat with Chr(39) because if you select 2 months at a time how this condition proves true?
I just gone to sunny reply, Can you try this?
If(GetCurrentField([Group1]) = '=if(Month=2,''Feb'',If(Month=3,''Mar'',if(Month=4,''Apr'',''May'')))', 'A', 'C')
Will you provide latest sample? and result you want to see in object?
Do you change single quotes from double quote in your expression? Looks like sunny's suggesting make sense. I am not sure where you made wrong.