Perform @CompIf function

13 posts / 0 new
Last post
William Yong
Offline
Joined: 06/30/2014 - 00:37

Hi Brian,
Thanks again on your assistance. I'm able to see the graph. But wondering why the graph still displayed my previous results even though I had input a new data? I suspect it should have to do with this line, Set db = Client.OpenDatabase(). How am I going to rectify it to prevent the graph from taking the previous data and not my latest data? Appreciate to glance through my script again whenever you are convenient. 
Million thanks, William.

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi William, just had a chance to look at your script a bit.  From what I can see you have hardcoded all your file names.  For the summarization you are summarizing the same file over and over again (see line 168) instead of summarizing the file you have selected, so I think that is your problem.  Change the database you are doing the summary on to the source file.

Pages