Formula indicator giving wrong value
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
6 hours ago
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
6 hours ago
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
6 hours ago
showing yearly data only
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
5 hours ago
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 hours ago

