Forum Discussion
Need help on Calculation
Hello,
I have a requirement as per screenshot below. It comes from one table with many columns.
Scope Impact Column {S1 reduction, S2 reduction}
MAAC Column {have positive and negative value}
IREC Availability Column {have postivie and negative value}
Payback Column {numeric value}
Can someone help me with the calculation? Should I created a calculated column in power query? I don't have the column for Points.
Thank you.
2 Replies
Hi Anonymous
Thanks for reaching out to us.
could you share some sample data? thanks
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Apologise, I could not upload the sample data due to restriction of company policies. Herewith is the some of sample data for reference.
PROJECT_ID SCOPE_IMPACT MAC IREC PAYBACK Project 1 Scope 1 -44 3 Project 2 Scope 2 0.466667 3 6 Project 3 Scope 2 -102 2 Project 4 0 4 Project 5 Scope 2 0.466667 3 6 Project 6 Scope 2 0 0 0 Project 7 Scope 2 -28 4 Project 8 Scope 2 -161 2 Project 9 Scope 1 -16 3 Project 10 Scope 2 -86 1 Project 11 Scope 2 -88 4 Project 12 Scope 2 -88 5 Project 13 Scope 2 -54 3 Project 14 Scope 2 -287 5 Project 15 0 5 Project 16 Scope 2 -237 2 Project 17 Scope 1 0.133333 -20 13 Project 18 Scope 1 0.1 2 2 Project 19 Scope 2 0.2 -4 4 Project 20 Scope 1 0 -12 -16 The result would see the point by project ID.
Thanks.
