Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago
Solved

change number to abs value using a filter condition

Hi,   Can you help me with a measure, basically i need to convert any negative numbers in my coloumn(ActualChrdHours) to positive number if my coloumn(ReverseVsMercurry) is "Not a reverse".   ca...
Need Help
Show and Tell
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    HI vjnvinod ,

     

    Your Switch column has created in different table than where yours Reverse and ActualChrdHours fields are coming. I suggest you to Right click on your DataDumpFull(2) Table at right side of Pane then click on create a New COlumn option.

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago

Tahreem24 

Super worked Like a charm

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

Hi vjnvinod ,

 

WOW!!! Finally,  am really very happy that I helped you to solve this problem! ðŸ˜Š

Good Luck!