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.
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.
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.