Dividing one row with another and create new row in same attribute.
Hello All i have date something like this .
What is want to achieve is divide each attribute with with row value say suppose in "OOP_BUCKET" we have 0-0 for both "Metric" Total claim and Total Reversal . I want to create new row 0-0 % where total count will be "27 / 244281" and same for 102-204 % rows say suppose APR-18 will be 147 / 5985.3. Attaching sample below .
The lower rows will be product of division of total reversal / Total claims .
Thanks in Advance looking forward to get more robust process for this task .
What is want to achieve is divide each attribute with with row value say suppose in "OOP_BUCKET" we have 0-0 for both "Metric" Total claim and Total Reversal . I want to create new row 0-0 % where total count will be "27 / 244281" and same for 102-204 % rows say suppose APR-18 will be 147 / 5985.3. Attaching sample below .
The lower rows will be product of division of total reversal / Total claims .
Thanks in Advance looking forward to get more robust process for this task .