How to give 95 % in the calculated fields?

Q&A
,
1

ifelse({BUSINESS SEGMENT} = “Genpact”,0.95,
{BUSINESS SEGMENT} = “FNWL”,0.93,
{BUSINESS SEGMENT} = “RLUS”,0.93,NULL)

this is not working in the output I am getting 0.95 and 0.93 as values instead of 95% and 93%

2

Hello Samiksha,

If the the calculated field is a measure you could format the Field to show as percentage. have you tried that ?

image

Hope this helps.
Cheers,
Deep

1 Like
3

Thanks Deep it worked .

I have one more query if you could help me in it , I am struggling in it since morning,pasting that logic here

KPI Goal
if ( ACTION_REQUIRED = 1 and Item_Score >= .95 and segment = Genpact and KPI_Target = “Meets” and QM_cnt = 1 then 1 )
if ( ACTION_REQUIRED = 1 and Item_Score <= .949 and segment = Genpact and KPI_Target = “Does Not meet” and QM_cnt = 1 then 0 )
if ( ACTION_REQUIRED = 1 and Item_Score >= 0.985 and segment = FNWL and KPI_Target = “Significantly Exceeds” and QM_cnt = 1 then 1 )
if ( ACTION_REQUIRED = 1 and Item_Score >= 0.955 and Item_Score <= 0.984 and segment = FNWL and KPI_Target = “Exceeds” and QM_cnt = 1 then 1 )

this is simple logic need to convert it to quicksight correct formula and I am unable to do so please help me everythime I am getting syntax error

1 Like
4

KPI GOAL =

ifelse(

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.985 AND {BUSINESS SEGMENT} = "RLUS", "Significantly Exceeds" AND QM Count = 1 , 1 ,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.955 AND {BUSINESS SEGMENT} = "RLUS", "Exceeds" AND QM Count = 1 , 1 ,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.93 AND {BUSINESS SEGMENT} = "RLUS", "Meets" AND QM Count = 1 , 1 ,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.851 AND {BUSINESS SEGMENT} = "RLUS", "Mostly Meets" AND QM Count = 1 , 0, 

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0 AND {BUSINESS SEGMENT} = "RLUS", "Does Not Meet" AND QM Count = 1 , 0,


{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.985 AND {BUSINESS SEGMENT} = "FNWL", "Significantly Exceeds" AND QM Count = 1 , 1 ,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.955 AND {BUSINESS SEGMENT} = "FNWL", "Exceeds" AND QM Count = 1 , 1 ,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.93 AND {BUSINESS SEGMENT} = "FNWL", "Meets" AND QM Count = 1 , 1 ,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.851 AND {BUSINESS SEGMENT} = "FNWL", "Mostly Meets" AND QM Count = 1 , 0,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0 AND {BUSINESS SEGMENT} = "FNWL", "Does Not Meet" AND QM Count = 1 , 0,


{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.95 AND {BUSINESS SEGMENT} = "Genpact", "Meets" AND QM Count = 1 , 1 ,


{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0 AND {BUSINESS SEGMENT} = "Genpact", "Does Not Meet" AND QM Count = 1 , 0,

"No Action Required"

)

This is what I tried creating but not working

5

Hello Samiksha,

Thank you for the feedback. could you open or have a separate thread for others to provide input and probable solutions. I will mark this thread as solution provided and look into other threads as well.

Thank you.

Cheers,
Deep

1 Like