Hi Everyone,
We want to create Risk report grouped by Entity and Risk statement, where we will be calculating the average of inherent rating, control effectiveness and residual rating coming from the risks based on entity and risk statement.
For eg: if we want to calculate the average of Inherent rating, of Risk statement -"abc" and Entity- "xyz", so here while calculating in the report, we will consider the first 3 rows, with R1, R2 and R3 risks, and avg inherent rating would be - 2.6+9+5= 16.6 /3 = 5.53.
Is this kind of dynamic filtering possible on the reports or PA side in ServiceNow? Any kind of help will be highly appreciated.
Thank you.
