Forum Discussion
Help with formula for indicator calculation
Hello, I have the following problem: at the time of calculating the indicators, these are not calculated properly, because it delivers as a result "infinite" and another inaccurate result (frame with blue image)
The formulas I use are the following:
when making the formula you mention, it does not give me any results
5 Replies
Syndicate_Admin , Use divide and check
divide(([CTP]+[FATAL])*1000000,[HH])
Syndicate_Admin , Please explain the issue now ?
In case you need 0
divide(([CTP]+[FATAL])*1000000,[HH],0)
it is not the result I need, I give you more details:
The total hours of the year 2021 are: 16,122,188
When extracting the CTP + FATAL gives me a sum of 13
When making the formula (12+1)*1000000/16.122.188 the total should be: 0.81
my database is this (attached excerpt. the first column is management, second column is the year, the third column is the month and year together and the final column is the total hours)
the ctp and fatal (CTP means with lost time and fatal means accidents with deceased people)
the formula I use to extract the data from the database, for example is this
CTP = CALCULATE(COUNTROWS(BD_SAP),BD_SAP[Type of injury] = "WITH LOST TIME")+0the database is as follows (extract attachment)
