Summary level data giving wrong result

[#1]

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

[#2]

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

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

-Alex