Assigning equal weights

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.

Preparation

Expression

Data Investigation

Accepted answers

Mchappell67

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

All comments

Mchappell67

Hi, @sriniprad08 -

This is what I came up with:

Mark

weight_recalc.yxmd

sriniprad08

Hi @Mchappell67 ,

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

Cheers,

Sri

Mchappell67

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703