Percentage of Total Calculation Using Values?

Question & Answer
, ,
1

Hi All

Can anybody help me understand why the % amounts in the caseid% columns pictured are not correct for the caseid columns (ie 3 of 30 should be 10%, etc.) ? Both columns are Values, with the caseid% being set to ‘Percentage of Total’ with the calculation ‘Table down’.

image
image525×211 18.8 KB

Thanks!

2

Hi @hopeah,
Is your ‘caseid%’ field a calculated field or did you just add caseid a second time and do a table calculation?

image
image527×324 22.6 KB

If it’s a calculated field, could you please share?
Also, is it possible for your ‘caseid’ field to have decimals?