spectrum17
asked on
How do I add an 'isnull' statement to the formula below?
I need the following formula to come up with a result of 0 if there aren't any records in the 'Leave_Taken' database.
Any ideas how to do this?
if date({Leave_Taken_csv.Leav e Start Date}) in
{?Start Date}to datetime({@annivdate}) then {Leave_Taken_csv.Hours Taken} else
if date ({Leave_Taken_csv.Leave End Date}) in
{?Start Date}to datetime({@annivdate}) then {Leave_Taken_csv.Hours Taken} else
else
0
Any ideas how to do this?
if date({Leave_Taken_csv.Leav
{?Start Date}to datetime({@annivdate}) then {Leave_Taken_csv.Hours Taken} else
if date ({Leave_Taken_csv.Leave End Date}) in
{?Start Date}to datetime({@annivdate}) then {Leave_Taken_csv.Hours Taken} else
else
0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER