RangeProd()??

[Jason_Michaelides]

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

[swuehl · Accepted solution]

Hi Jason,

try using

=exp(rangesum(above(log(sum(Sales)),0,rowno())))

Regards,

Stefan

[Jason_Michaelides]

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