Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Look at RangeSum function if in doubt post your qvf file.
Something like:
RangeSum(Above(Count(inv),0,RowNo()))
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
Ok Good luck and let us know the result.