Hi All,
Am using below expression to calculate number of business days in a month.
if i use this data item as a row in a crosstab few columns are not displaying values.
Can anyone help me on this..
((cast(_days_between(?EndDate?,1900-01-01)/7,integer)*5)+if(_day_of_week(?EndDate?,1)>5) then (4) else (mod(_days_between(?EndDate?,1900-01-01),7))+1)
-
((cast(_days_between(?StartDate?,1900-01-01)/7,integer)*5)+if(_day_of_week(?StartDate?,1)>5) then (4) else (mod(_days_between(?StartDate?,1900-01-01),7))+1)
+
(if(_day_of_week(?StartDate?,1)<6) then (1) else (0))
Thanks in advance
try to either create another query that wrap the query you used for the crosstab or put your computed field in the FM model, so crosstab see it only a number field.
achieved...