Need help !!!!!!!!

[#1]

Hi All ,

I have QVW doc i calculated variance buy using actual(A) and  Target(T)

Finally I got some value Now i want to calculate count

how may 0 are there in my variance i want calculate in  any object

as well <0 how may are there like that

please see the attachments

[maxgro · Accepted solution]

try with

=count(if (aggr(CAS_Date_Value1-CAS_Date_Value2, CAD_Activity_ID, CAM_ID)>0, CAM_ID) )

instead of

=if(vVarience >0,count(vVarience))