Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

basic math formula - Formula In-DB

cstafford
8 - Asteroid

fairly new to Alteryx and trying to build a simple math calculation. I am trying to calculate and average using Formula In-DB and getting incorrect results. Below is my formula:

 

"fieldname1" / 13

 

It is returning results but the math is incorrect and static; every line has the same result.

3 REPLIES 3
ivoller
12 - Quasar

Are the output type and the "fieldname" types correct? Perhaps you need to cast the "fieldname"? What database, field types are you using?

cstafford
8 - Asteroid

My issue was in the summarize tool as I had the action set to 'group by' when it should have been 'sum'.

manchun
5 - Atom

I am looking for Math Formulas for study. i got your community but not get proper formulas for Math. i got Math formulas from andlearning.org. thank you for discussion. if you have any idea related to Math please share.  

Labels
Top Solution Authors