My case:

(

  SUM (

    CASE

      WHEN

        PU_COUNT (

          "Vorgänge_mElement_xlsx_Sheet1_CASES" ,

          "Vorgänge_mElement_xlsx_Sheet1"."Aktivitätsbezeichnung" ,

          "Vorgänge_mElement_xlsx_Sheet1"."Aktivitätsbezeichnung" = '<%= Abbruchaktivitaet %>'

          AND

          "abgeschlossen_xlsx_Sheet1"."ABGESCHLOSSEN" = 1

        )

        >

        0

      THEN

        1

    END

  )

)

/

( SUM ( CASE WHEN "abgeschlossen_xlsx_Sheet1"."ABGESCHLOSSEN" = 1 THEN 1 END ) )

If I only calculate the dividend, the correct value appears, also if i individually calculate the divisor. But when I try to calculate the quotient, the result is wrong.

For example the dividend = 4 and the divisor = 9 the result need to be 0.444 but it appears 0.797 as result. Is that a bug by Celonis or what did I make wrong?

Thank you in advance.

Kind regards,

Ivo