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