community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Sum certain field cells based off certain criteria of the row

Meteor

Okay so I've updated everything and here's what I have.

 

The account field is set to string

The entity field is set to string 

The Total field is set to double

 

After using the updated formula I am still getting an error, this time it says "The formula "New Entity" resulted in a string but the field is numeric. Use ToNumber(...) if this is correct. (Expression #1)

Asteroid

You can put a ToNumber() formula before both the Entity and Account fields, however it doesn't seem like you will be performing any arithmetic calculations off of this field. Is your New Entity field type set to a String or a Double? If it's set to a Double right now, please change it to a String within the formula tool itself.

Highlighted
Meteor

That fixed it the error. I am heading home for today and I'll try to see if I can get this workflow to do what I need it to do. Thanks for all the help, you rock!

Asteroid
Perfect!! Glad that fixed the error =). If you have any questions it's definitely helpful to attach your workflow to the post. Makes it a lot easier to troubleshoot by letting anyone here work through your actual workflow.

In case you're unfamiliar with saving your packaged workflow, you can save it by going to Option > Export Workflow. Be sure to select everything that appears in the window and save your workflow from there. This allows the saved package workflow to be sent to others or posted here with the saved data sources/files you are using in your workflow. More info on this can be found here: https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Export-Workflows-with-Attachments-Assets/ta-...
Labels