You need to sign in to do that
Don't have an account?
ALI WAHEED
Add up number of Cases from a Date onwards
Hello -
We have new price structure for our 2015 Servces, which was rolled out on 09/08/2015. And we have a 2015 New Fee Date field which captures the Date the client was informed of this new price structure. So, in case they sent us a case before we cound introduce our new price structure, they will not be charged the new fee.
I am having to generate a report to only show the Cases that came in After the 2015 New Fee Date. Somehow i keep getting all the cases that came in before the 2015 New Fee Date. I may need to create a field that catches the cases after the new date.. So, I may need a formula to add the number of cases. Can you please guide.
Thank you.
We have new price structure for our 2015 Servces, which was rolled out on 09/08/2015. And we have a 2015 New Fee Date field which captures the Date the client was informed of this new price structure. So, in case they sent us a case before we cound introduce our new price structure, they will not be charged the new fee.
I am having to generate a report to only show the Cases that came in After the 2015 New Fee Date. Somehow i keep getting all the cases that came in before the 2015 New Fee Date. I may need to create a field that catches the cases after the new date.. So, I may need a formula to add the number of cases. Can you please guide.
Thank you.
James Loghry
What do your report filters look like? Also, you should be ommitting any cases with a null or blank new fee date as well.