Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I know RangeProd() does not exist (currently, I hope!) and that there is an "idea" already raised for this (please vote - http://community.qlik.com/ideas/1105), but I have a requirement to achieve this now...
I am using Above() to get an array of values. I can use RangeSum(Above(Sum(Sales),0,RowNo()) to sum all these values together, but does anyone have any bright ideas how to multiply all the values together?
Thanks,
Jason
Hi Jason,
try using
=exp(rangesum(above(log(sum(Sales)),0,rowno())))
Regards,
Stefan
Hi Jason,
try using
=exp(rangesum(above(log(sum(Sales)),0,rowno())))
Regards,
Stefan
Dude - we have to meet so I can attach some kind of genius-extracting-device to your head! I saw your previous post on a similar thread but couldn't quite get it to work.
Confession time - although this will certainly be something I will need in the future, this was actually the last piece of a puzzle I needed to solve someone else's challenge... http://community.qlik.com/thread/54368?tstart=0
Thanks again Stefan - and for responding so quickly!
Jason