Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Improve the accuracy of catalog item reporting

Manu143
Tera Contributor

‎02-09-2024 04:22 AM

Hi Community,

 I have one requirement -

  1. 1. Need to create New Variable in  one catalog item:

    • A new variable (yes/no) named "AccurateCalculation" is added to the catalog item form.
    • The variable is based on the total dollar amount of the purchase and automatically set to "yes" if the total dollar amount meets certain criteria(e.g amount is >=100k dollar).

  2. 2: Calculation Logic for "AccurateCalculation":

    • The calculation logic for "AccurateCalculation" is implemented to evaluate whether the total dollar amount warrants a "yes" value.
    • Criteria for setting the variable to "yes" are defined and implemented in the purchase request form.

  3. 3: Application of New Variable to Reporting Feature:

    • The "AccurateCalculation" variable is integrated into the reporting feature to ensure accurate representation of asset values.
    • A comprehensive test is conducted to confirm that the reporting feature correctly considers the new variable.
  4. 4.How to achieve this?  AccurateCalculation(Yes/No) variable should not display on catalog form it's for the reporting purpose.

 

Thanks,

Manu

 

0 Helpfuls
  • 323 Views
2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

‎02-09-2024 04:27 AM

Hi @Manu143 

 

  1. 1. Need to create New Variable in  one catalog item:

    • A new variable (yes/no) named "AccurateCalculation" is added to the catalog item form.
    • Atul: Create a variable and with type Yes /NO
    • The variable is based on the total dollar amount of the purchase and automatically set to "yes" if the total dollar amount meets certain criteria(e.g amount is >=100k dollar).
    • Atul: Put a UI policy for this on total amount.

  2. 2: Calculation Logic for "AccurateCalculation":

    • The calculation logic for "AccurateCalculation" is implemented to evaluate whether the total dollar amount warrants a "yes" value.
    • Criteria for setting the variable to "yes" are defined and implemented in the purchase request form.

  3. 3: Application of New Variable to Reporting Feature:

    • The "AccurateCalculation" variable is integrated into the reporting feature to ensure accurate representation of asset values.
    • A comprehensive test is conducted to confirm that the reporting feature correctly considers the new variable.
  4. 4.How to achieve this?  AccurateCalculation(Yes/No) variable should not display on catalog form it's for the reporting purpose

ATul: You can easily create the Report on variables.

 

It is simple use case and I must say, try at your end and you can do. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

SunilKumar_P
Giga Sage

‎02-09-2024 04:32 AM - edited ‎02-09-2024 04:33 AM

Hi @Manu143, you can try below.

 

  • A new variable (yes/no) named "AccurateCalculation" is added to the catalog item form.

--> Create a 'AccurateCalculation' variable and hide it on the Catalog Item view, requested Item View and Catalog task view using the UI Policy.

 

  • The variable is based on the total dollar amount of the purchase and automatically set to "yes" if the total dollar amount meets certain criteria(e.g amount is >=100k dollar).

-->Once the requested is submitted, you can query the purchase value and if the value is >=100K dollar, set the 'AccurateCalculation' value to yes using the (current.variables.<variableName> == true / 'Yes') in the workflow.

 

 

Regards,
Sunil