Hi Guys
I have a expression that is being used in bar chart and it is giving some value for count of Ids. When I am using the same expression in straight table to see those Ids then it is giving nothing. I am unable to get it. As this is confidential data so could not share it.
Count(Distinct If(condtn A AND condtn B,ReportId,Null())) it is giving some value
and when i am using If(condtn A AND condtn B,ReportId,Null()) in a straight table to see those ReportIds it is giving - for all.
Kindly suggest some debugging methods to solve it