1
vote
Show as blank rather than 0.00% (Decimal showing as %)
Try using calculated column formula like this:
=IF(ISBLANK([Figure]),"",[Figure]/100)
Notes:
Sometimes comma(,) does not work in formula (it is based on language or regional settings on ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
sharepoint-server × 84992013 × 1578
sharepoint-enterprise × 1474
sharepoint-online × 720
sharepoint-foundation × 624
sharepoint-designer × 615
2016 × 531
powershell × 489
2010 × 479
list × 365
workflow × 324
javascript × 278
development × 276
2019 × 245
search × 226
document-library × 223
sharepoint-addin × 200
sharepoint-on-prem × 196
web-part × 189
permissions × 169
sharepoint-rest-api × 166
infopath × 160
csom × 143
designer-workflow × 138
rest × 124