Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Is it possible to filter a variable? Eg: vMyvariable = Sum (sales)+Sum(Margin)
Then filter this variable by year:
Sum({<Year = {'2017'}>}vMyvariable)
Regards,
Daniel M
Thats not possible directly
Sum cannot used against sum again.
The possible way is use the set analysis within the vMyvariable expression. Let me know if you are facing any issues with that.
Try the below, it might be work but not sure
Sum({<Year = {'2017'}>}Aggr(vMyvariable, Year))
Thats not possible directly
Sum cannot used against sum again.
The possible way is use the set analysis within the vMyvariable expression. Let me know if you are facing any issues with that.
Try the below, it might be work but not sure
Sum({<Year = {'2017'}>}Aggr(vMyvariable, Year))
Hi,
Try like this,
1) create a variable like below, let me know if any issues?
Alt(Sales,0)+Alt(Margin,0)
2) Expression like this
SUM({<Year = {'2017'}>} $(Variable1))
is Sum(Sales)+Sum(Margin) the same as Sum(Sales+Margin)?
if yes, you can have a variable to hold the 2 fields as text and use $ to execute :
Variable1 : Sales+Margin
Expression : $(='Sum({<Year = {'2017'}>} ' & Variable1)