Calculation Problem

[khasimvali85]

Hi COmmunity,

                    Could you Please find the what the problem Here? In Call column not displaying exact values

Count	CompNo	Call
7	JOD0108130227 : JOD0108130244 : JOD0108130296 : JOD0208130006 : JOD0208130024 : JOD0208130024 : JOD0208130164	1 : 1 : 1 : 1
2	KAR0108130079 : KAR0108130142	1 : 1
1	SAN0108130225	1
3	KOL0108130073 : KOL0108130127 : KOL0108130275	1 : 1
14	LUC0108130124 : LUC0108130172 : LUC0108130180 : LUC0108130181 : LUC0108130214 : LUC0108130214 : LUC0108130227 : LUC0108130235 : LUC0208130013 : LUC0208130057 : LUC0208130159 : LUC0208130207 : LUC0208130250 : LUC0208130293	1 : 1 : 1 : 1 : 1 : 1 : 1 : 1 : 1 : 1 : 1

Regards

Khasim.

[anbu1984]

What is Call column?

Can you attach sample qvw.

[pandiarajan]

Dear Khasim,

     Plz send the exact expression what u are using here

[khasimvali85 · Accepted solution]

Hi Pandiarajan,

                    Thanks for replying in my Table i couldn't given the right Expression means date field couldn't given so its not showing right values,when i given right date field the expression  working fine now.

The Expression is given below:

=Concat(

         If(

             AGGR(

                   SUM({< CallDate=,DataDate=,FetchDate=,DATEField={'$(=vVariableName)'} >}CALLS),COMP_NO)>=3,COMP_NO),' : ')

Regards,

Khasim.

[#5]

Can you please close the question by marking relevant answers as correct or helpful

Thanks,

Singh

[pandiarajan]

great my dear go ahead

[khasimvali85]

Dear Pandiarajan,

                         Thanks Pandiarajan sure i will go through.

Regards,

Khasim.