Forum Discussion

skopcak's avatar
skopcak
Icon for Helper I rankHelper I
9 years ago

maximum and minimum value in decimal numbers a rows - query editor

Hello,

Can you please advise how the query editor power to do this? Thank you

 

 

Item No.01/01. Item Price10/01. Item Price20/01. Item Price30/01. Item Price05/02. Item Price25/02. Item Price05/03. Item Price08/04. Item Price09/05. Item Priceresult maximumresult minimum
1234567895,246,846,258,457,435,897,598,959,529,525,24
987654325,243,846,2510,457,435,897,598,959,5210,453,84
Need Help

4 Replies

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    9 years ago

    skopcak

     

    Select All your columns except Item No.

     

    Go to Add Column--Statistics - And Select Maximum or Minimum

     

    • skopcak's avatar
      skopcak
      Icon for Helper I rankHelper I
      9 years ago

      OK, thank you, please give it about getting on decimal numbers? Integers me it goes, but when, I will set decimals, so this box is not active.

      • Vvelarde's avatar
        Vvelarde
        Icon for Community Champion rankCommunity Champion
        9 years ago

        skopcak

         

        you should'nt have problems with decimals in this operation.

         

         

        Before check the type of your columns. Are there recognize like numbers?

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi skopcak,

     

    The Statistics feature can also work when you check more than one decimal number columns in Query Editor. Please check how many columns you selected, and verify the data type are Decimal Numbers.

     

     

     

    Best Regards,
    Qiuyun Yu