Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Hi Jodie, You could try using a Custom Formatting rule that says if the field = null, then display "N/A". Instead of using valueexpression, remove the column and then add the 2018 Proposed Tax column again. This time add a conditional format (see the attached image) Here is the text mode as well:
displayname=2018 Proposed Tax
linkedname=direct
namekey=2018 Proposed Tax
querysort=DE:2018 Proposed Tax
textmode=true
valuefield=2018 Proposed Tax
valueformat=customNumberAsCurrencyStringRounded
case.0.comparison.leftmethod=DE:2018 Proposed Tax
case.0.comparison.lefttext=DE:2018 Proposed Tax
case.0.comparison.righttext=
case.0.comparison.operator=isnull
case.0.comparison.operatortype=double
case.0.comparison.icon=false
case.0.comparison.truetext=N/A
styledef.case.0.comparison.leftmethod=DE:Test
styledef.case.0.comparison.lefttext=DE:Test
styledef.case.0.comparison.righttext=
styledef.case.0.comparison.operator=isnull
styledef.case.0.comparison.operatortype=double
styledef.case.0.comparison.icon=false
styledef.case.0.comparison.truetext=N/A </pre>
Let me know if that helps. Best regards, Dan Dan Perkins Moventus
Views
Replies
Total Likes
Views
Replies
Total Likes