Remove negative values in reports of PA

[Alia]

Hi Team,

We have a report which shows the negative value after calculation using formula indicator. To avoid that negative value, we added *-100 in the formula indicator however now its showing negative for the positive values as well. 

Is there a way we can set the positive values to positive only using the formula indicator.

#performanceanalytics ServiceNow

#Dashboards

#Reports

[Mark Manders]

If you do a calculation and that calculation is correct and it ends up being a negative number, it's still correct, right? 

Manipulating data to not show negative, doesn't make sense. 10-14 = -4, not 4. 

What is the calculation you are doing? What do you want to show, because it sounds like the issue is in there.

[Alia]

I am trying to calculate the gross margin %. Formula i have used is [[ GrossMargin]] / [[Total Revenue]] * -100

since it was giving negative value in the GM%. So added -100 to remove the negative ones however now I feel we have to consider for both the Total Revenue as well as the Gross Margin since if any one of them is negative or anyone of them is positive we have to use the if else condition. I am trying with the if else as well however its not working.

Please assist in how we can use the If else condition here. 

[Mark Manders]

But if the gross margin is negative, you should get a negative percentage, right? On every product of 10 euro you sell with a gross margin of -1 euro, your gross margin percentage is -10%. It's not 10, it's not 1, it's -10%. 

I think it's more weird that you can get positive values when you have a total revenue of -100 dollar with a negative gross margin of 10 dollar (-10/-100 = 10)