8 Replies Latest reply: May 2, 2016 6:46 AM by Madeleine Josefsson RSS

    KPI problems

    Madeleine Josefsson

      Hi,

      I have created a measure that tells me wether the assigment is insured or not with the following function: (StandardInsured = '1' or Household='1')

      Now I would like to create a KPI using this measure, where the KPI tells me how many % of the chosen assignments that are insured. I tried with the following formunal for the KPI: count(StandardInsured = '1' or Household='1')/count(AssignmentNo)

      But this does not give me a correct value.

       

      Does anyone have any ideas on how to solve this?

       

      Thanks!