Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)))
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)))
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)))