4 Replies Latest reply on Aug 31, 2018 6:51 AM by MANOJ PRABHAKAR

# Tableau Calculations- How to show 0 % for null values for a single measure value

Tableau Calculations- How to show 0 % for null values for a single measure value

Call Volume % = COUNTD([Id])/TOTAL(COUNTD([Id]))*100

This is working fine , but 0 % is not showing up

• ###### 1. Re: Tableau Calculations- How to show 0 % for null values for a single measure value

Call Volume % = ZN(COUNTD([Id])/TOTAL(COUNTD([Id]))*100)

This will give the 0%

If it didn't kindly attach a workbook so that it will be easy helps

If it helps kindly mark this answer as correct and helpful

BR,

NB

• ###### 2. Re: Tableau Calculations- How to show 0 % for null values for a single measure value

Hi Naveen B for null % values the 0% is not showing up

• ###### 3. Re: Tableau Calculations- How to show 0 % for null values for a single measure value

ZN(LOOKUP( (COUNTD([Id])/TOTAL(COUNTD([Id]))*100),0 ))

Try This it will help

BR,

NB

1 of 1 people found this helpful
• ###### 4. Re: Tableau Calculations- How to show 0 % for null values for a single measure value

AWESOME , THANKS BUDDY Naveen B U SAVED MY DAY