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 

 

still doesn't helps

 

Switch function doesn't reads my table coloumn, see below, hence the Switch logic doesn't works

 

 

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
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!