1 Reply Latest reply on Apr 13, 2018 11:49 AM by Martin Dunleavy

Average Calculations

sivasagar kalagara Apr 13, 2018 11:34 AM

Hello Team,

How to write calculation for the below code

CAST(((Count_of_QSI)/((TotalQSI)))*100 AS Decimal(5,2))

Regards,

Sivasagar

1. Re: Average Calculations

Martin Dunleavy Apr 13, 2018 11:49 AM (in response to sivasagar kalagara)

Are your "Count..." and 'Total..." measures already numbers? or strings? If they're numbers already, it should automatically create another number with a decimal. You can then format the number to display to tenth, hundredth, and so forth. So, you can just do

((Count_of_QSI)/(TotalQSI))*100
Like Show 0 Likes(0)

Actions

Tableau Community Forums