I am facing a strange error:
We have following table with DTI(report level variable).
DTI<.40=Count([Query 2].[Lead Id] Where([DTI]<0.4))
DTI >= .40 & <=.45=Count([Query 2].[Lead Id] Where([DTI]<=0.45 And [DTI]>=0.4 )) ForEach([Case Completed MonYear])
It shows the values correctly.
However once I remove lead id from this it shows following
As you can see in above image we have a lead DTI>.7 and 1 in .5 & .7.
My report need the last table but its not showing the count correctly.
I tried using foreach on lead id or case completed mon year but it doesnt work.