How to show avg issued qty in crystal report of sap business one?

[Former Member]

I am new in SCN. my question is related to crystal report. 1. I want to show issued quantity of items according to each month and avg of issued quantity in graph form. For Example:- when i select date range between month and By selecting Items code:- Report show:--- Item code    Item name  Onhand Qty  issued qty  jan  feb march    april    may  june  july  august  sep  oct  nov  Dec    Avg issued qty                                                                       Graph:- Change of month selection /  show issued qty.. Please help me..I dont know how to do this.

[former_member1269712]

Hi Anshul,

Welcome to Community Network...

This question is related to Crystal report so you have to post there right now you posted this on SAP BO Application category.

Still see as per your requirement all sock figures you will get in stock tables just segregate them based on transaction date it means make this report in tabular format where you will get expected output monthwise and insert running field after last month where you may select average same just like we are doing for sum. Just instead of sum you need to select AVG.

Regards,

Sachin