Hello Team,
How to write calculation for the below code
CAST(((Count_of_QSI)/((TotalQSI)))*100 AS Decimal(5,2))
Regards,
Sivasagar
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
Become a Viz Whiz on the Forums! Support the Community and master Tableau.