Forum Discussion

tempranello's avatar
tempranello
Advocate I
10 years ago
Solved

Test for a number

Hi there   I must be losing it...this seems such a simple thing to do, but I'm blowed if I can sort this out myself.   I've a column of type text in a query that may or may not contain text or a ...
  • chrisu's avatar
    chrisu
    10 years ago

    I think you want to use Value.Is.  To check if a value is text, it would look something like this:

     

    Value.Is([Column],type text)

     

    To check for a number, it would be:

     

    Value.Is([Column], Int64.Type)

     

    Value.Is returns a boolean true/false, so you can wrap it in an IF.  

  • Anonymous's avatar
    Anonymous
    8 years ago

    Worked for me. Thank you!

     

    if Value.Is(AlphaNumeric, type text) then AlphaNumeric else Number.ToText(AlphaNumeric))
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Another take on this, applied to an [Index] column: Divide the value by the "TestMultiple" to test, then round to 0 decimals, then multilply back again and test if resulting value is equal to original value:

[Index] being any column with numbers

[TestMultiple] the factor: 3, 5, 7, etc....

 

Number.Round([Index]/TestMultiple,0)*TestMultiple=[Index])