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

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