Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

ISEVEN FUNCTION not working correctly

Hello,    I am trying to use the "ISEVEN" function to see only even numbers on a column. I don't know the reason it is giving me wrong results (please refer to the picture attached).    I a...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

     

    Regards,
    Frank

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

What are the results for that data that you would want? There is probable a way to achieve it. If you want it based on the very last number, for example, you could use this:

 

Column 2 = ISEVEN(RIGHT(CONCATENATE([Column1],""),1)*1)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I would like to see only even whole numbers (no decimals). 

     

    I tried using this formula for that but didn't work. 

     

    Column 2 = ISEVEN(RIGHT(CONCATENATE(ECS_EZQuery40[DEBIT_AMOUNT],""),3)*3)