Assigning equal weights

[sriniprad08]

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.

[Mchappell67]

Hi, @sriniprad08  -

This is what I came up with:

Mark

[sriniprad08]

Hi @Mchappell67 ,

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

Cheers,

Sri

[Mchappell67 · Accepted solution]

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