Dynamic variable

[Chanty4u]

Hi All,

i m using below expression  with static value it is working   .. but when i place variable it is nor working what might be the issue?

My variable is 

vNewMaxQtr     =  2018Q3

so i need to use  instead of 2018Q3   the variable should be placed

Thanks

Chanty

[sunny_talwar · Accepted solution]

This isn't working?

=if(max(Dimensionality())=1,

sum({$<Quarter={"$(=vNewMaxQtr)"},Type={'Fc'}>}Amount),

if(max(Dimensionality())=2,

sum({$<Quarter={"$(=vNewMaxQtr)"},Type={'Fcc'}>}Amount),

if((Dimensionality())=0,sum({$<Quarter={"$(=vNewMaxQtr)"},Type={'Fc'}>}Amount))

+sum({$<Quarter={"$(=vNewMaxQtr)"},Type={'Fcc'}>}Amount)))

[sunny_talwar]

or

=if(max(Dimensionality())=1,

sum({$<Quarter={"$(=$(vNewMaxQtr))"},Type={'Fc'}>}Amount),

if(max(Dimensionality())=2,

sum({$<Quarter={"$(=$(vNewMaxQtr))"},Type={'Fcc'}>}Amount),

if((Dimensionality())=0,sum({$<Quarter={"$(=$(vNewMaxQtr))"},Type={'Fc'}>}Amount))

+sum({$<Quarter={"$(=$(vNewMaxQtr))"},Type={'Fcc'}>}Amount)))