Skip to main content
Question

Wrong result when adding percentages

  • May 19, 2025
  • 0 replies
  • 15 views

varvara.bachu
Level 1
Forum|alt.badge.img

Dear Community,

I want to calculate an average error rate for each year under certain conditions. Even though it may seem quite simple, I receive an incorrect result.Β πŸ€”

This is my formula:

COUNT (DISTINCT (β€œTable”.”Column”))

/

COUNTΒ (DISTINCT (β€œTable”.”Column”)).

Β 

The KPI β€œ2023” has the following conditions as filters:

Β 

Do you have any idea what isΒ wrong with my formulas?Β 

Many thanks and kind regards,

Varvara

0 replies

Be the first to reply!