Forum Discussion

Rokie_101's avatar
Rokie_101
New Member
4 years ago

Dynamic Number Format

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.