Perform @CompIf function

William Yong

Forums

Greetings,
I have a scenario where i need to do some records filtering by fulfiling 3 conditions in a single database file, e.g. Amount < 0, 'Low', Amount > 0 And Amount <=5, 'Moderate' and Amount > 5, 'High'. How am I able to perform those 3 conditions by Low, Moderate & High where in the end, I need to produce a graph based on those key conditions. I try use the @compif function, i.e. @CompIf(Amount < 0, "low", Amount > 0 .AND. Amount <= 5,  "moderate", amount > 5, "high"  ) and it returned a result that I'm not expecting of. How am I suppose to group the 3 conditions? What is the correct @function to use here or any solution/advice for me.
Thanks. William
 

William Yong Fri, 07/03/2015 - 03:45

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 Mon, 07/06/2015 - 07:51

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.