Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
as I have a chart expression that I use often, I would like to convert it into a macro so that I can easily call it when needed.
The chart expression is as follows:
=(a*$(n)+b*$(m)+c*$(m)*$(q)+d*$(n)*$(q))*Valueloop(1,$(o)) -(a*$(n)+b*$(m)+c*$(m)*$(q)+d*$(n)*$(q))*(Valueloop(1,$(o))-1)
Where m,n,o,q are values entered by the user with the input fields.
where a,b,c,d are imported fields (size=1).
What is the equivalent of this expression in scripting as a function?
Thanks in advance
Maybe you are looking for a master measure?
Morgan Kejerhag
Senior Business Intelligence Consultant
Drake Analytics
http://www.drakeanalytics.se