Forum Discussion

alice11987's avatar
alice11987
Icon for Helper I rankHelper I
3 years ago
Solved

Add suffix to the matrix table

Hi there,

 

I have tried to add suffix "Days" to the matrix table by changing the dataset format to "#,###.00 \D\a\y\s",

but for zero days, it shows as ".00 days"; instead, I would like it to show "0.0 days". 

 

Before: 

 

After:

 

 

Thank you

  • Hi alice11987 ,

     

    You need to add the additional place holder for the units try one of the following:

    #,##0.00 \D\a\y\s
    
    #,##0.00 "Days" 

     

1 Reply

  • Hi alice11987 ,

     

    You need to add the additional place holder for the units try one of the following:

    #,##0.00 \D\a\y\s
    
    #,##0.00 "Days"