Skip to main content

... we set up a custom process to analyse ourSoftware and evaluate its performance. Therefore we would like to "simply" multiply two KPIs. (Calculation a.) * b.)) However the calculation does not work.

 

a.) (SUM (CASE WHEN PU_COUNT ( "BITMPT_OCRHIST_BATCH", "BITMPT_OCRHIST_SOURCE"."SOURCE" ) = 0 THEN 1 ELSE 0 END

) ) / COUNT("BITMPT_OCRHIST_BATCH"."MANDT")

((

 

b.) ((SUM(

CASE WHEN PU_COUNT("Case_Invoice_Processing", "View ABBYY_Invoice"."AutomationState",

"View ABBYY_Invoice"."AutomationState" LIKE 'manual' ) > 0

  THEN 1

  ELSE 0

END)

 

/

((SUM(

CASE WHEN PU_COUNT("Case_Invoice_Processing", "View ABBYY_Invoice"."AutomationState",

"View ABBYY_Invoice"."AutomationState" LIKE 'manual' ) > 0

  THEN 1

  ELSE 1

END))))))

Hi @marco.messn ,

Which error are you getting?

Sometimes for long queries as yours it's better to save each KPI to a formula and then make operations later.


Reply