Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all...
I just need to know how to calculate (sum) the product based on the date of purchase...
Eg.Tv is 40000 and next tv is need to be 80000.... like this need to add by product by upcoming....
If u need more details find the PFA..
Thank You
Thanks To all...
I just Get the answer myself which is working for this...
=Aggr(RangeSum(Above(sum(Price),0,RowNo())),Product,Date)
Regards,
Apache
Hi David thank you.... I just tried your code.... but its not working.....
Thanks To all...
I just Get the answer myself which is working for this...
=Aggr(RangeSum(Above(sum(Price),0,RowNo())),Product,Date)
Regards,
Apache