Formula indicator giving wrong value

[pramn]

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! 

[KanteS]

Hi,

First, check whether the formula is referencing the yearly time series and the source indicators are collecting yearly scores.

The formula is currently using By year SUM as mentioned above, try updating it to By month SUM.

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

When inserting the indicators in the formula editor, make sure to select “By month SUM” from the Time Series dropdown before adding the indicator.

if my answer is helpful give a like and mark it as solution

Thank you

[pramn]

Its giving attached output

[KanteS]

did u run historical data collector job after updates?

[KanteS]

and also try to change the drop down manually to monthly