Forum Discussion
Group By Option
Hi,
Not sure why my Group By option is giving error. Both data and formula as below:
Regards
Malvika
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
3 Replies
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
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
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
