Forum Discussion

SACooper's avatar
SACooper
Icon for Helper II rankHelper II
4 years ago
Solved

Performance Against Target Measure giving weird results within Matrix

  The measure is as follows:   VAR _daysInView = COUNTROWS(VALUES(CIVICA_CompletedItems[ProcessedDate])) VAR _numberOfStaff = COUNTROWS(VALUES(CIVICA_CompletedItems[ProcessedBy])) -- VAR...
Need Help
  • Luuky's avatar
    Luuky
    4 years ago

    Hi SACooper, 

    What i mean is for example

    KP = (1908-1685)/1685

    LW = (494-820)/820

    MW = (1090-1572)/1572

    This should give the value I assume you are looking for.

    Greetings,

    Luuk

SACooper's avatar
SACooper
Icon for Helper II rankHelper II
4 years ago

<insert favoured expletive here> thank you for pointing this out, basic math that I should have be well adept at, tunnel vision, is the only excuse I can come up with.

 

This works perfectly ... still confused why my previous math didn't work out but this did the trick 

 

Thank you!