Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to create a variable with varying conditions depending on the month of the quarter, i have used below formulae for the same in Data Load editor:
if Mod(Month(Today()),3)=0 then
Set vTest = Sum({$<[Projection.Period]={'$(=Max([Projection.Period],2))'}>} [Projection.Projection]) ;
elseif Mod(Month(Today()),3)=1 then
Set vTest = Sum([Projection.Projection]);
else
Set vTest = Sum({$<[Projection.Period]={'$(=Max([Projection.Period]))'}>} [Projection.Projection) ;
end if;
I have used these variables in application but it's not working except for the part where set analysis is not there
Why set analysis cannot be computed in if statement?
Thanks,
Arvind
Try this
if Mod(Month(Today()),3)=0 then
Set vTest = Sum({@<[Projection.Period]={'@(=Max([Projection.Period],2))'}>} [Projection.Projection]) ;
elseif Mod(Month(Today()),3)=1 then
Set vTest = Sum([Projection.Projection]);
else
Set vTest = Sum({@<[Projection.Period]={'@(=Max([Projection.Period]))'}>} [Projection.Projection) ;
end if;
SET vTestFinal = "=Replace($(vTest), '@', '$')";
give a try with the below syntax:
LET vTest = 'Sum( {< [Projection.Period]={' & chr(39) & chr(36) & '(=Max([Projection.Period])) ' & chr(39) & '} >} [Projection.Projection])';
This is not working.
Set analysis works while creating a measure and giving it a formula.
But i want this measure to have a dynamic value using set analysis.
This is not working.
Set analysis works while creating a measure and giving it a formula.
But i want this measure to have a dynamic value using set analysis.
what is not working?
could you share a sample qvf?
Can you help on how to upload sample file as there are only image and video upload options.
try searching for advanced editor option somewhere...i already did it so I can't see that option anymore...
May be try the approach which Stefan talks about here