Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Assigning equal weights

sriniprad08
11 - Bolide

Hi Team,

 

Hope you are well.

 

I need help. Please find below the input and the output. 

Currently - I am manually entering the KRI and assigning the percentage equally based on the number of KRI  0.1 so that it all adds up to 1.

Its manual now. I have to enter the KRI and assign 0.1 

Is it possible that when i enter the new KRI "G" below in the output it automatically recalculates the percentage and assign the value to it and sums up to 1?

Thank you.

sriniprad08_0-1638801302098.png

 

3 REPLIES 3
Mchappell67
9 - Comet

Hi, @sriniprad08  -

 

This is what I came up with:

 

Mchappell67_0-1638801966010.png

Mark

 

sriniprad08
11 - Bolide

Hi @Mchappell67 ,

Thank you very much. Really appreciate it. Can you please explain the macro part a bit ?

 

Cheers,

Sri

Mchappell67
9 - Comet

Hi - 

 

The only macro part that I'm aware of in what I posted is the "Record Count" tool.  Simply getting the total number of records in the input to use in the weight calc.

 

Mark

 

Labels