Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
(1+a1)(1+a2)....(1+an)
If I understand the question
='(1+' & Concat(num#(Date), ')(1+') & ')'
Lets say a1,a2 ...an are sales values on the dates filter selected.Like we do Sum(sales),I want to do something like this
Multiply(1+sales)
How can i achieve this ??