How to change a single number field in all rows to a negative value in a table?

  • 1
  • Question
  • Updated 10 months ago
  • Answered
I have a table that has a single column where every value needs to be changed to a negative.  Is there an easy way to do this?
Photo of Jeremy Aranda

Jeremy Aranda

  • 124 Points 100 badge 2x thumb

Posted 10 months ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Add a UI Only field to your model that executes a formula . {{MyField}}*-1

Then show that field in your table. 
Photo of Jeremy Aranda

Jeremy Aranda

  • 124 Points 100 badge 2x thumb
I ran the field update off the UI field and it worked great.  Thanks.