We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Formula indicator giving wrong value

pramn
Kilo Sage

Hi Team ,

below formula is giving yearly data , but we would required monthly data 

if ({{PPM - Number of Closed Projects / By year SUM +}} != 0 ) {
([[PPM - Number of On-Time Delivered Projects / By year SUM +]] / {{PPM - Number of Closed Projects / By year SUM +}}) * 100
} else {}

 

What Do i need to change ?

Thanks for your help! 

 

 

8 REPLIES 8

Mark Manders
Giga Patron

You expect a query on yearly indicators to return monthly data? What happens if you make them into monthly indicators?


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

showing yearly data only 

KanteS
Giga Guru

Hi 

for  better understanding, could you please share a few additional details?

• What is the collection frequency of the source indicators (PPM - Number of Closed Projects and PPM - Number of On-Time Delivered Projects)?
• Are these Automated Indicators configured with Data Collector Job ?
• When you check the Indicator Scores, do you see monthly score records or only one score per year?

This information will help identify whether the issue is related to the indicator configuration or the way the data is being displayed.

Thanks!

Attached the print screen