I have a report that i need to calculate the days reguardless of instances. The out put now is this...
Date TASK Hours Days
2005-01-01 this task 8 1
2005-01-02 this task 8 1
2005-01-02 different 2 1...
I am fairly new to Actuate. I am working on a report that has 12 fields (ETC1-ETC12) I want to add them together, then subtract ETC. Only problem is that there are NULLS in say ETC7-ETC12 because no time is recorded yet. How do i write either a SQL code or Function to handle the NULL values...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.