Forum Discussion
Hep with the formula
Super UserThe first item is simple
For your second item you need to provide a sort order. Is it supposed to be alphabetic by Controls?
Not sure what the expected outcome should look like for point 2.
Hi,
1. Can you please tell me what will be the calculation for the summing up which you did in the above picture?
2. I have given the expected outcomes in the last two columns of the table- Gross risk burndown and actual risk burndown.
| iskname | Controls | Gross_risk_potential | Actual_risk_reduction | Completed date | Gross_potential_burndown_remaining | Actual_risk_burndown |
| Risk 1 | A | £10 | £5 | 04-04-2024 | 35-20=5 35=sum of gross risk potential based on the risk name till time period(04-04-2024) 20=gross risk potential for control A and control B as the completion date is same for both the controls | 35-15(10+5)=20 |
| Risk 1 | B | £20 | £10 | 04-04-2024 | 35-20=5 35=sum of gross risk potential based on the risk name till time period(04-04-2024) 20=gross risk potential for control A and control B as the completion date is same for both the controls | 35(gross risk potential)-15(10+5)=20 35=total sum of |
| Risk 1 | C | £5 | £2 | 30-04-2024 | 5-5=0 1st 5=last gross risk potential before the completion date(30-04-2024) 2nd 5=gross risk potential for control C | 35-17(5+10+2)=18 |
| Risk 2 | D | £10 | £5 | 04-04-2024 | 50-10=40 50=total sum of sum of gross risk potential based on the risk name 10=gross risk potential for control D until the time period. | 40 |
| Risk 2 | E | £25 | £10 | 30-04-2024 | 40-40=0 40= Total sum of gross risk potential until the time period(30-04-2024) 40=sum of gross potential for controls E and F as the completion date is same for both of them | 35 |
| Risk 2 | F | £15 | £4 | 30-04-2024 | 40-40=0 40= Total sum of gross risk potential until the time period(30-04-2024) 40=sum of gross potential for controls E and F as the completion date is same for both of them | 35
I want the last two columns, gave a desirable output along with the calculation. Based on the last two columns i want to create a burndown for the risks on how they are reducing on a regular period with the implementation of controls
|
- lbendlin
1. I used implicit measures directly in the visual.
2. I am very much lost, I don't understand a single one of these calculations. I hope someone else can help you further.
Can you please help me figure out how to get the 1st point values in a formula rather than in a visual. I need a column of those calculations so that i can try to figure out the second part of the problem. Im not able to get the calculations in a column using any formula.
