Sharepoint JSON column formatting - negative numbers

Iron Contributor

Hi

 

I am using this JSON for column formatting:

 

{

     "elmType": "div",

     "txtContent": {

         "operator": "floor",

         "operands": [

             {

                 "operator": "/",

                 "operands": [

                     {

                         "operator": "-",

                         "operands": [

                             "=Number('[$_x0035_6_x0020_days_x0020_date]')",

                                                  "=Number('@now')"

                         ]

                     },

                     86400000

                 ]

             }

         ]

     }

}

 

It works but it displays negative numbers, I want all negative numbers to display as '0'.

 

How can I do this?

 

 

 

0 Replies