I have a formula that will not work in the Report Header but will work in Details.
I created a formula to add a day to a parameter date {?Start Date}+1. I did this for 7 days. I then wrote a formula to give me the total hours based on type of hours for each day.
First formula: This is based on just the start date parameter without adding +1.
if {Coverage.TYPEOFHOURS} = "ON DUTY CREW" and
{Coverage.DATEIN} = {?Start Date} then {@TotalHours}
Second formula: this is same as above but using Start date parameter +1.
if {Coverage.TYPEOFHOURS} = "ON DUTY CREW" and
{Coverage.DATEIN} = ({?Start Date}+1) then {@TotalHours}
The first formula works in both the Detail section and the Report Header. The second formula will only work in the Detail section. When I place it in the header I get 0.00 instead of 24.00.
Any solutions?
I created a formula to add a day to a parameter date {?Start Date}+1. I did this for 7 days. I then wrote a formula to give me the total hours based on type of hours for each day.
First formula: This is based on just the start date parameter without adding +1.
if {Coverage.TYPEOFHOURS} = "ON DUTY CREW" and
{Coverage.DATEIN} = {?Start Date} then {@TotalHours}
Second formula: this is same as above but using Start date parameter +1.
if {Coverage.TYPEOFHOURS} = "ON DUTY CREW" and
{Coverage.DATEIN} = ({?Start Date}+1) then {@TotalHours}
The first formula works in both the Detail section and the Report Header. The second formula will only work in the Detail section. When I place it in the header I get 0.00 instead of 24.00.
Any solutions?