Select First and last month of the year

[faroukfrk]

Hello

i am new to Qlik Sense and i want to calculate the avrege of Stock with this formula

Average of Stock = (Stock Quantity at the year start + Stock Quantity  at the end of the year ) / 2

Thank you in advance

[Arthur_Fong]

Hi Farouk,

Refer to the attached for the output you required.

Also refer to the script if you would want to know more how to grab the fields used in the dashboard.

Thanks and regards,

Arthur Fong