hello I'm sorry for the inconvenience I hope you're okay I will try to explain to you a case in navision I have a flowfield field in the vendor card which calculates the evaluation of each vendor by each reception until everything is fine after a meeting with the client, he wants this field to display the vendor’s average per semester (1st semester of 01/01-->06/30)(2nd semester of 07/01-->12/31) but by example we are on 04/17/2022 the average grade that must be displayed is from the 2nd semester of the year 2021 roughly this average must display the average grade of the semester - 1. I added another date type field in the vendor table a flowfilter and I integrated it into the average rating field in the same table and in the page vendor I added a function scorevendor which will have a setfilter of the field but I don't know how to give it in the parameters especially I don't know how to write a code to calculate the score for semester-1 . I hope you understand my case. while waiting for your return, I wish you a good day
