Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors