Calculate the monthly average sales of the item by taking the last six months sales and display it on item card

how can we create monthly acerage sales by taking last six months sales

You can either create a variable on the form and calculate it here on the fly.

Or you can create a copy of the “Sales (LCY)” field and change Sum to Average in the flowfield calculation. Then set the datafilter to 6 months.

Or you can combine the two and set the field and datafilter on the onAFTERGETRECORD on the form.

please can u explain in brief …

Hi Mahesh,

What is your connection to Prasamsa? Not only does your questions and way of writing looks very much the same, but you’re also connecting from the same location (IP visible to admins/moderators only).

yes mr. erik , we r from same team in an organisation , trainees in nav,…