12 Replies Latest reply on Dec 2, 2019 9:58 AM by shruten parmar

# Please help me transform high percentages to percentages below 100

Please see figure below.

My percentages are 1918472%, which is abnormal. How would i change this to 19%?

• ###### 1. Re: Please help me transform high percentages to percentages below 100

Hi Sook - Young,

Instead of dividing the values and then summing up, first sum and divide.

For Example

You are doing : [Sales]/ [orders] and then summing up

Do : Sum([Sales])/Sum([orders]) then keep this calculated field into marks card as AGG([Value])

Please mark as correct and helpful if this helps.

Thanks,

Shruten

• ###### 2. Re: Please help me transform high percentages to percentages below 100

I am sorry, I am new to Tableau and do not understand the syntax/commands you have suggested.

• ###### 3. Re: Please help me transform high percentages to percentages below 100

I think we'll need to see a sample workbook so we can see how you've done the calculations.

• ###### 4. Re: Please help me transform high percentages to percentages below 100

I actually have not done any calculations except for these:

1. Cohort Score (All)

{FIXED [Competency Area]:AVG([Student])}*100

1. Student Score

[Student]*100

• ###### 5. Re: Please help me transform high percentages to percentages below 100

No Worries!

Can you please tell me what is the calculation for Cohort Score and Student score?

If you are doing any operations (sum,subtract,division or multiplication)  between two fields. First use "Sum" Function before the field.

Please let me know this helps.

Thanks,

Shruten

• ###### 6. Re: Please help me transform high percentages to percentages below 100

The problem is that we don't know what any of this means without the context of the workbook. Any chance you could mock up some sample data and share the workbook with us?

• ###### 7. Re: Please help me transform high percentages to percentages below 100

Shruten,

I am sorry, I do not know the calculation for these scores other than the ones I indicated in my reply above...

And I am not using any operations between the two fields. I am open to any and all suggestions

• ###### 8. Re: Please help me transform high percentages to percentages below 100

Ken,

By the workbook, would you mean the data source?

• ###### 9. Re: Please help me transform high percentages to percentages below 100

I mean the Tableau Packaged workbook--the twbx file. Packaged Workbooks - Tableau

• ###### 10. Re: Please help me transform high percentages to percentages below 100

Hi Sook-Young,

Please follow the steps as mentioned below,

Step 1 - Change the formula into :

1. Cohort Score (All)

{FIXED [Competency Area]:AVG([Student])}

1. Student Score

[Student]

Step - 2 Do formatting to Number(Custom) Format <- And keep two decimal places <- and add % into suffix,  please refer the below image.

Let me know if this helps.

Thanks,

Shruten

2 of 2 people found this helpful
• ###### 11. Re: Please help me transform high percentages to percentages below 100

Dear shruten parmar,

It did help the decimal places go way down.

I realized my problem, however, is this:

I have several (3~8) items for each competency area (A--- has 3 questions in the survey, for example).

I need the AVERAGE for the three items .... and all this for each competency area.

Would you happen to know how to do this?

Thank you.

• ###### 12. Re: Please help me transform high percentages to percentages below 100

Hi Sook-Young,

Glad it worked out.

You can use directly Avg function to get the average values. If this doesn't get you the values as expected use the LOD Function Fixed/Include.

Let me know if you need anything for this.

Thanks,

Shruten