Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hmm, those look like variables , and the dollar sign is missing everywhere
if([Employment]<=$( vMonthStart ) ..
-Alex