Hey there,
One way to do this is to add a global variable (set to the same value as diffTotal) and some conditional logic to check to see if that variable is greater than or = 0.
You can use the logic you’ve already got, just change it to:
-$[[((LVAR1 - LVAR2)*-1).toFixed(2)]].
This way you place the ‘-’ outside of the dollar sign, and you multiply the sum by -1.
Make sure you toggle ‘if/else’ on your cases, so that each case reads IF. Here’s the file with those updates:
money formatting.rp (65.9 KB)
Note** In my file I used a widget to test my variable. I deleted the widget, but forgot to delete the logic to update the text on the widget.