Hi. I am analyzing the information of a business. This is complex in terms of the logic of the statuses of insurance plans, since I need to generate a current policy count table by month-year and by making a simple expression Count ({<[Portfolio.State] = {'Valid'}>} Portfolio.Policy ) I get an extremely minor result of policies per month-year against the actual data that I would have to arrive to.
I have the fields of DateEmission and DateEnd of the policies so I think to create a logic that plays with these fields. What do you advise me to develop this table?
