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

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

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

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?

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

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

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