topic QS does not support Full Accumulation in App Development

QS does not support Full Accumulation

paulyeo11 — Tue, 20 Oct 2015 02:00:27 GMT

Hi All

Below code work fine in QV with Full Accumulation turn on.

count(distinct(if(inv>'800000' and inv<'899999' and year,inv)))

But in QS , it does not have Accumulation.

May i know how to modify the script above ?

Paul

robert_mika — Tue, 20 Oct 2015 04:43:49 GMT

Look at RangeSum function if in doubt post your qvf file.

Something like:

RangeSum(Above(Count(inv),0,RowNo()))

paulyeo11 — Tue, 20 Oct 2015 15:29:00 GMT

Hi Robert

Thank you for give me the link , i will try out myself by read the post , in case i still unable to make it , i will post my doc here.

Paul

robert_mika — Tue, 20 Oct 2015 20:38:43 GMT

Ok Good luck and let us know the result.