Why is the Revenue at Risk for a product in the Resilinc portal is not matching with the total revenue provided in the CDIF file?

Created by Amit Kadam, Modified on Wed, 27 Aug at 7:03 AM by Amit Kadam

  • The Revenue at Risk for a product in the Resilinc portal is calculated based on the system's current logic, which considers only the first row of revenue data for each product listed in the CDIF file.
  • If a product has multiple revenue entries across quarters (Q1, Q2, Q3, or Q4) in the CDIF, the system uses the revenue values from the first occurrence of that product and ignores all subsequent rows.
    • For example, in the case of the product GALAXY_testProduct, the following revenue data was provided in the CDIF:

 

 


    • However, the system calculates the Revenue at Risk using only the revenue values from the first row for GALAXY_testProduct. The calculation is as follows:
    • Revenue at Risk = Q1 + Q2 + Q3 + Q4
      = $10092.75 (Q1) + $10092.75 (Q2) + $10092.75 (Q3) + $10092.75 (Q4)
      = $40371 (approximately $40K)
    • This matches the value displayed in the portal. The subsequent rows for the same product are not included in the calculation as per the current system logic.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article