Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

need to get average in a particular field.

vikrantsenapati
7 - Meteor

Hello everyone i'm new to altery i'm stuck at a particular place please help.

20 REPLIES 20
vikrantsenapati
7 - Meteor

Please a lower version will be helpful.

vikrantsenapati
7 - Meteor

Vikrant1_0-1600672946126.png

Error: Multi-Row Formula (20): Parse Error at char(0): Formula: tried to apply numeric operator to string value

 

atcodedog05
22 - Nova
22 - Nova

Hi @vikrantsenapati ,

 

Can you mention which version ?

vikrantsenapati
7 - Meteor

unable to open the file. can u please send me in any other format or by changing family dependency.

atcodedog05
22 - Nova
22 - Nova

Hi @vikrantsenapati ,

 

It's version issue. Tell me which version I will change it to it.

atcodedog05
22 - Nova
22 - Nova

Hi @vikrantsenapati 

 

I have downgraded to 2019.1 can you try it.

grazitti_sapna
17 - Castor

@vikrantsenapati ,it was just a warning,irrespective of that issue the workflow was working fine.Anyways, I have deselected the extra column now it is working fine.

Thanks.

Sapna Gupta
vikrantsenapati
7 - Meteor

my version is 2019. this not the output which i want. The field "2018 Average Pool Balance" is the average of "12/31/2017 Pool Balance" and "12/29/2018 Pool Balance". Further "average turn" is "2018 Issuance"/"2018 Average Pool Balance".

 

atcodedog05
22 - Nova
22 - Nova

Hi @vikrantsenapati ,

 

Apologies. Please find the correct workflow. 

 

And workflow is 2019 version

vikrantsenapati
7 - Meteor

tx a lot

Labels