Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Datatable - Values Negative - Show Positive - Stacked Column Chaart

Hi I have a datatable showing negative values.

In my Stacked Column Chart I want to show them as positive values, any suggestions?

I do not want to add a column referring to the column making the amounts positive.

 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous 

     

    Have you tried using ABS(yourtable[ColumnName]) ?

     

    ABS funtion will convert the negative numbers to postive numbers.

     

    I am a bit curious to know any specific business rule or scenario that you want to show the negative values as positive in the stacked column chart.

     

    Cheers

     

    CheenuSing

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous 

     

    Have you tried using ABS(yourtable[ColumnName]) ?

     

    ABS funtion will convert the negative numbers to postive numbers.

     

    I am a bit curious to know any specific business rule or scenario that you want to show the negative values as positive in the stacked column chart.

     

    Cheers

     

    CheenuSing