Forum Discussion

joe231's avatar
joe231
Frequent Visitor
4 years ago
Solved

HELP with Negative Return Values

Hi All -

 

in a measure column, I am Trying to calculate %difference between 2 columns (Result 1 column) that results into Negative values. I want the negative values to positive and keep the positive values as positive. 

 

I simply could  mulitply the column to -100 but it also affects positive values and turns them into negative.

 

 

I was hoping  an "if" modification in this formula

 

 

 

  • Adescrit's avatar
    Adescrit
    4 years ago

    Hi joe231 ,

     

    How about this:

    % Difference = 
VAR __Measure_Value = Data[Result2] 
VAR __Baseline_Value = Data[Result1]
VAR __Calculation = DIVIDE( __Measure_Value - __Baseline_Value , __Baseline_Value )
RETURN
    IF( __Calculation < 0, __Calculation * -1, __Calculation )

2 Replies

  • Adescrit's avatar
    Adescrit
    Impactful Individual
    4 years ago

    Hi joe231 ,

     

    How about this:

    % Difference = 
VAR __Measure_Value = Data[Result2] 
VAR __Baseline_Value = Data[Result1]
VAR __Calculation = DIVIDE( __Measure_Value - __Baseline_Value , __Baseline_Value )
RETURN
    IF( __Calculation < 0, __Calculation * -1, __Calculation )
  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support
    3 years ago

    Hi joe231 ,

     

    Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.

     

    Best regards,

    Yadong Fang