Help need for Average Stock

Discussion in 'Requests' started by imranlhr, Jan 26, 2021.

    
  1. imranlhr

    imranlhr Member


    Dear Experts,

    I am working on stock report and facing one problem in calculating Average Stock. So, i request to all experts please help me.

    Formula of Average Issued Stock is: Issued Stock /Period or number of days

    Issued Stock i calculated from Stock journal billed qty. but i need help how to calculate number of days based on selection of period of report. e.g. i select report date from 01-12-20 to 31-12-20. then how i can make formula of number of days based on selection of date.
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Make a button in your desired report, where you want to calculate.

    Make a variable and assign it to the Report level also.

    In the calculation field......... in SET AS : define if selecteddays then thisforumula else defaultformula.

    In "thisformula" you can calculate the days difference.
     


  3. imranlhr

    imranlhr Member



    Thanks Alot Sir,

    After many practices i completed my Issuance Summary Report. Sir i use simple formula after alot of searching in tally developer and i found a solution which is
    $$Number:$$NumOfMonths:##SVfromDate:##SVTodate i hope this formula will helpful for others who are searching such solutions.
     

    Attached Files:



Share This Page