Skip to main content

Hi Team,

 

Currently when we use a formula field in report builder to get a average by adding few other fields and if any field is having null values system is taking that field as 0 and making the average . Customer wanted to ignore the fields if there is no value present for a field and get the average only for the fields if there is any value in it.

 

Example 

Lets Say , I have three fields A, B,C Now A = 1 and B = 2 and C = Null (0) In formula field .. Currently system is taking as A+B+C/3 i.e 1+2+0/3 = 1 (Average Value)  … But customer wanted to ignore the 0 and change the denominator to 2 as one field is null and calculate the value .. Like 1+2/2 =1.5 

Currently I don’t see we can achieve this in our report builder . Any thoughts on it ?

Hi @sandeepchidiri 

We have multiple usecases from multiple customers for the same functionality. After a bug where we were skipping nulls, we have started to considering nulls as 0’s so as to accommodate for one use-case. Now we are hearing the 2nd one. cc: @rahul_prayakarao 

Thank you @sandeepchidiri and @rakesh for your assistance with this use case. We are using surveys 2.0 to poll our customers on the performance of their CSM team. When a customer skips a question, it scores 0 and brings down the CSM’s average performance score. I appreciate your consideration.

Reply


Terms & ConditionsCookie settings