udaykamble
Programmer
round( (
case when ([Database View].[ResourceAssignment].[Remaining Start Date]>_add_days([Database View].[Project].[Data Date],43)) THEN (0)
when ([Database View].[ResourceAssignment].[Remaining Finish Date]<_add_days([Database View].[Project].[Data Date],43))
then ([Database View].[ResourceAssignment].[Remaining Units] )
else
([Database View].[ResourceAssignment].[Remaining Units] * (43 - _days_between([Database View].[ResourceAssignment].[Remaining Start Date],[Database View].[Project].[Data Date]))/_days_between([Database View].[ResourceAssignment].[Remaining Finish Date],[Database View].[ResourceAssignment].[Remaining Start Date]) )
end)/7/40, 2)
I am getting following error : I am not sure why as it is working in another report.
QE-DEF-0030 Expression parsing error.
QE-DEF-0359 The query contains a reference to at least one object '[Database View].[ResourceAssignment].[Remaining Start Date]' that does not exist.
case when ([Database View].[ResourceAssignment].[Remaining Start Date]>_add_days([Database View].[Project].[Data Date],43)) THEN (0)
when ([Database View].[ResourceAssignment].[Remaining Finish Date]<_add_days([Database View].[Project].[Data Date],43))
then ([Database View].[ResourceAssignment].[Remaining Units] )
else
([Database View].[ResourceAssignment].[Remaining Units] * (43 - _days_between([Database View].[ResourceAssignment].[Remaining Start Date],[Database View].[Project].[Data Date]))/_days_between([Database View].[ResourceAssignment].[Remaining Finish Date],[Database View].[ResourceAssignment].[Remaining Start Date]) )
end)/7/40, 2)
I am getting following error : I am not sure why as it is working in another report.
QE-DEF-0030 Expression parsing error.
QE-DEF-0359 The query contains a reference to at least one object '[Database View].[ResourceAssignment].[Remaining Start Date]' that does not exist.