Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm after some hep with the syntax for an expression in a chart please?
I have three dimensions:
Period, Account and GLActual
I'd like to construct a combo chart with two expressions:
Sum(GLActual) as a column, which I can do no problem 🙂
I would then like a flat line which shows 80% of the average of the sum of selcted periods, please see examples below where Series 1 is the basic actual sum and series 2 the 80% average of the cumulatie:
Any help would be greatly appreciated.
May be this
Avg(TOTAL Aggr(Sum(GLActual), Period)) * 0.80