Forum Discussion

MalvikaBhasin's avatar
MalvikaBhasin
Helper III
2 years ago
Solved

Group By Option

Hi,   Not sure why my Group By option is giving error. Both data and formula as below:           Regards Malvika
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi MalvikaBhasin ,

     

    The error message shows the type of Profit column is not Number, Please add a step of changing Profit column to Number type before using Sum of Group By step.

     

    Please select one number type you want. I suggest you try whole number firstly.

     

     

    Best regards,

    Mengmeng Li

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MalvikaBhasin ,

 

The Sum of GroupBy just supports number, your ‘Order ID’ column is text type. Could you please show more details about your requirements about the first GroupBy step?

 

If you want to show count of table in ‘CountNew’ column, I suggest you use Count Rows in Operation as follows.

 

 

Best regards,

Mengmeng Li

  • MalvikaBhasin's avatar
    MalvikaBhasin
    Helper III
    2 years ago

    Hi,

     

    Below is Group by option that I used, and Group By Error that is generated.

    Kindly suggest on how to solve this. 

     

     

     

    Regards

    Malvika

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi MalvikaBhasin ,

       

      The error message shows the type of Profit column is not Number, Please add a step of changing Profit column to Number type before using Sum of Group By step.

       

      Please select one number type you want. I suggest you try whole number firstly.

       

       

      Best regards,

      Mengmeng Li