cancel
Showing results for 
Search instead for 
Did you mean: 

Paxata SUM function

StephanieWhit12
Blue LED

Paxata SUM function

I'm trying to compute the sum of 3 numeric columns.

My formula looks like this:

Sum(@Success@,@Fail@,@Exception@)

But am getting Error:Expected (Number) got (String).

Not sure how to fix it? My columns are numeric, not all the rows have actual values, not sure if that matters?

 

paxata screen.png

0 Kudos
2 Replies
Anonymous
Not applicable

Hi @StephanieWhit12 ,

 

This is Sudheer. Please let me know if you need help with @akshay suggestion. You can access this functionality by hovering the mouse pointer on the little inverted orange icon. Please let me know if you run into any issues.

 

sudheerkumar_0-1644009250398.png

With Best Regards

Sudheer Kumar

0 Kudos
akshay
DataRobot Employee
DataRobot Employee

Can you do a change into function for all the three columns to numeric? I notice that even though the datatype of the column is numeric, the zeros are stored as text. Paxata picks the datatype based on the majority of the column values (which seem to be numeric)

0 Kudos