1 Reply Latest reply: Aug 10, 2018 2:44 PM by Sunny Talwar RSS

    Logic to count insurances with current status

    Leandro Gallo

      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?

       

        I appreciate your help greatly greetings