Summary level data giving wrong result

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

while displaying date in flat table output is fine

But when it is summed up then total is not matching.

Code used in flat table

(

if(

[Employment WET]>=vMonthStart and Designation<>'Partner' and IsText(Descipline_Utilization) and IsText(Discipline_Utilization_MainGroup)

if([Employment WET]<=vMonthEnd,[Employment WET]+1,vMonthEnd)-

if([Employment WEF]<=vMonthStart,vMonthStart,[Employment WEF]))/(vMonthEnd-vMonthStart)

)

Code used at summary level

sum(distinct

if(

[Employment WET]>=vMonthStart and Designation<>'Partner' and IsText(Descipline_Utilization) and IsText(Discipline_Utilization_MainGroup),

( if([Employment WET]<=vMonthEnd,[Employment WET]+1,vMonthEnd)

if([Employment WEF]<=vMonthStart,vMonthStart,[Employment WEF])

)

,0)

)

sum(distinct

if(

[Employment WET]>=vMonthStart and Designation<>'Partner' and IsText(Descipline_Utilization) and IsText(Discipline_Utilization_MainGroup),

(

(vMonthEnd-vMonthStart)),0

)

Thanks

Nishant

Tue, 07 Dec 2010 10:33:57 GMT

Hmm, those look like variables , and the dollar sign is missing everywhere

if([Employment]<=$( vMonthStart ) ..

-Alex

topic Summary level data giving wrong result in QlikView