# Feature - Custom Report Macro for Risk Threshold

**URL:** https://discussions.eramba.org/t/feature-custom-report-macro-for-risk-threshold/3891
**Category:** Forum - Software
**Tags:** question
**Created:** [November 30, 2023, 4:02pm UTC](https://discussions.eramba.org/t/feature-custom-report-macro-for-risk-threshold/3891 "2023-11-30T16:02:02Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![stenberg](https://discussions.eramba.org/letter_avatar_proxy/v4/letter/s/f05b48/32.png) [@stenberg](https://discussions.eramba.org/u/stenberg)
#### Post date: [November 30, 2023, 4:02pm UTC](https://discussions.eramba.org/t/feature-custom-report-macro-for-risk-threshold/3891/1 "2023-11-30T16:02:02Z")

</div>

Hi,

I am creating a custom report in the Risk Management and I am looking for the Makro for the Risk Threshhold.  
I can see the macro for the Risk Score %RISK\_RISK\_SCORE\_ANALYSI% but then I only get the number and not the value from the Risk Appetite.

Any advices?

Thanks!

---

<div class="post-metadata">

### Author: ![stenberg](https://discussions.eramba.org/letter_avatar_proxy/v4/letter/s/f05b48/32.png) [@stenberg](https://discussions.eramba.org/u/stenberg)
#### Post date: [December 4, 2023, 8:09am UTC](https://discussions.eramba.org/t/feature-custom-report-macro-for-risk-threshold/3891/2 "2023-12-04T08:09:33Z")

</div>

Does anyone have any ideas on this question?

Have I made it clear what my problem is?

---

<div class="post-metadata">

### Author: ![sam](https://discussions.eramba.org/letter_avatar_proxy/v4/letter/s/5f9b8f/32.png) [@sam](https://discussions.eramba.org/u/sam)
#### Post date: [December 4, 2023, 9:24am UTC](https://discussions.eramba.org/t/feature-custom-report-macro-for-risk-threshold/3891/3 "2023-12-04T09:24:46Z")

</div>

Hello,

Right now, there is no macro for the threshold or classification.  
I’m creating an issue.

Int. ref.: [https://github.com/eramba/eramba/issues/4552](https://github.com/eramba/eramba/issues/4552)

---

<div class="post-metadata">

### Author: ![emily.kennewell](https://discussions.eramba.org/letter_avatar_proxy/v4/letter/e/8797f3/32.png) [@emily.kennewell](https://discussions.eramba.org/u/emily.kennewell)
#### Post date: [February 6, 2024, 1:10pm UTC](https://discussions.eramba.org/t/feature-custom-report-macro-for-risk-threshold/3891/4 "2024-02-06T13:10:02Z")

</div>

Here’s a pseudo-code example of how this could be implemented:  
// Retrieve Risk Appetite Threshold  
risk\_threshold = retrieve\_risk\_threshold\_from\_database()

// Retrieve Risk Score  
risk\_score = %RISK\_RISK\_SCORE\_ANALYSI%

// Compare with Threshold  
if risk\_score \> risk\_threshold:  
result = “Risk Exceeds Threshold”  
else:  
result = “Risk Within Threshold”

// Display Result  
print(result)

---

<div class="post-metadata">

### Author: ![kisero](https://discussions.eramba.org/user_avatar/discussions.eramba.org/kisero/32/2925_2.png) [@kisero](https://discussions.eramba.org/u/kisero)
#### Post date: [February 8, 2024, 12:51pm UTC](https://discussions.eramba.org/t/feature-custom-report-macro-for-risk-threshold/3891/5 "2024-02-08T12:51:04Z")

</div>

> [@stenberg](#):
>
> Makro for the Risk Threshhold

Documenting this in more detail:

- you are trying to create an Item Report on the Asset Risk module
- when you drop a text widget
- You select macros
- you miss Analysis and Treatment Thresholds
- The same happens for the notifications

 ![image](https://discussions.eramba.org/uploads/default/original/2X/c/c134d7e7f4a872544776113b6880e4a97676b85f.png)

Thanks