Hi Everyone,
I hope you're all doing well.
May I ask your help on how can I apply dynamically the format function with my existing formula.
Objectives: I want to format some of the selected value as "Percent", "Whole number" and "Decimal".
Existing formula:
AGENT LEVEL METRICS =
SWITCH(TRUE(),
(SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "ATTENDANCE RATE", [Attendance Rate],
SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "UTILIZATION", [UTILIZATION],
SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "PRODUCTIVITY", [PRODUCTIVITY COMPLETED SCORE],
SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "PROD RATE", [PROD RATE],
SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "AHT ADHERENCE", [AHT ADHERENCE SCORE],
SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "AGENT PRODUCTIVITY", [AGENT PRODUCTIVITY SCORE],
SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "QA REGULATORY MISSED", [QA REGULATORY MISSED],
SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "QUALITY", [QA PASS RATE],
SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "TOP ERRORS", [TOP ERROR],
SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "AGENT PASS RATE", [AGENT PASS RATE SCORE])
The following are the selected value that I want to dynamically change with its respective format.
[Attendance Rate] as a "Percent"
[UTILIZATION] as a "Percent"
PRODUCTIVITY COMPLETED SCORE] as a "Percent"
[PROD RATE] as a 2 "Decimal"
[AHT ADHERENCE SCORE] as a "Percent"
[AGENT PRODUCTIVITY SCORE] as "Percent"
[QA REGULATORY MISSED] as a "Whole Number"
[QA PASS RATE] as a "Percent"
[TOP ERROR] as a "Whole Number"
[AGENT PASS RATE SCORE] as a "Percent"
Thank you in advance.
