Showing negative number as positive but also making sure the Total Row is summing correctly

verytiredgirl
verytiredgirl Member
edited January 16 in Cards, Dashboards, Stories

I have pivot table that looks something like this: Cost of Sales Others & Expenses are negative so that the Subtotal & Total are calculated correctly.

I know you can show the negative either in red (with a minus sign in front) or in financial style. But is there anyway to get rid of the positive sign but still making sure that the Subtotal and Total rows are correct?

image.png
Tagged:

Comments

  • GrantSmith
    GrantSmith Coach

    Because how Domo processes the data with the Pivot table you can't have your data elements display positive but your total negative and vice versa. I'd recommend logging an idea in the idea exchange to allow for this.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • DavidChurchman
    DavidChurchman Coach

    You could use the "financial style negatives (100)" option, which is a standard way to deal with this, and uses parentheses instead of negative signs:

    image.png

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Categories