Hi,
Does anyone know why when i run the attached report and return to design mode i have an extra Total column with no formula in there?
Basically what i'm trying to do is add the Actual + Budget range based on the start and end dates of each, it appears to work when i first run it but then i run it again and get the extra Total column
Any help would be good
Cheers, Michael
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi Michael,
Don't know why this is happening but it has to do with your function in cell F1. Here's something that solved it for me (Jet Essentials 2013 update 1).
- Cell F1: Fit
- Cell B1: Hide+?
- Cell F2: =IF(EndDate="30/06/2014";"Hide";"")
(Info on Conditionally hiding in case you need it: http://kb.jetreports.com/article/AA-00522)
Does it work for you?
Cheers,
Hans -
Jet Reports Historic Posts Excellent worked out perfectly
Cheers, Michael
Please sign in to leave a comment.