Group By Option

[MalvikaBhasin]

Hi,

Not sure why my Group By option is giving error. Both data and formula as below:

Regards

Malvika

[v-mengmli-msft]

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]

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

[v-mengmli-msft · Accepted solution]

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