EndzoneHero Posted July 3, 2018 Share Posted July 3, 2018 Hi all, We've just moved to Pulseway so I've tasked a junior with filling out all the Warranty info. To that end I added a custom field: "Warranty Date: Explanation if none" for machines where there was no warranty info - e.g. a virtual machine or where the service tag was simply not recognised by the vendor website. I then created an ad-hoc report to track his progress. I've used quite a few report builders and think I've got my head round this one but something has me really stumped: either I'm missing a bug in my grouping formula OR the grouping is screwed. Before you ask - "Why are you using nested ifs for the grouping?", I would like to say that I did use a switch, saw the effect I am about to describe, then tried a nested if and can see the same thing The grouping statement should only have 3 outcomes: "Got info", "Not needed" and "No info". The right hand columns are my workings to try and see why I see the problem. The problem is shown below the report screen grab below The "No info" group appears twice: Both in the pie chart and in the table below (which i can't repeat because it contains client info). To add insult to injury the numbers in the two "No info" groups change randomly. I ran this 30 seconds later: If someone could please help it would be much appreciated. I had great confidence in the product and was very excited to see such a nice report builder, but am concerned to hit a roadblock so quickly. Thanks EndzoneHero Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now