AnsweredAssumed Answered

Count CHG.ref_num not counting properly

Question asked by ijreis on May 17, 2016
Latest reply on May 18, 2016 by ijreis

Hello all !!!

 

i would like to apply to your experience, in order to progress with a Report development!

 

In this particular case, we need to count the total of CHG.ref_nums and ISS.ref_nums from some select statements.

In theory, just adding the Measure defined as =Count([Chg.Ref_num]) should return the proper counter , but instead, the resultes returned are completely far away from the reality.

 

I mean, for a particular time range, my Statement returns 10 different Chg.Ref_nums values/rows, but when i set a new column on my TOTAL COUNTERS report sheet, with the measure Total Chg Ref Num , the value is completely wrong, for example " 4200" ... or " 78" for the next row ...

 

I've also created a new variable, set as "=Count([chg.persid]), but the result is the same!

 

Any idea or hint?

 

Greetings.

Ivo

Outcomes