Are you a Crystal Pro? I am not.
I have a report that calculates Conference Room Usage charges for each Client. Clients have free hours of usage each month so the report has to figure out when their free usage is exhausted then charge hourly rates based upon which room they have used. The report works nicely, except for the first time they go over their usage allotment. The formula needs to prorate and I do not see a way how in Crystal. See the image below: The Blue rectangle record is the first time this client has gone over. The report charges for 2.5 hours of usage, but it should only charge for 1 hour as the user has only gone over by 1 hour. So for the first time the user goes over their free usage I need to calculate the charge as ((FreeUsage – AccumalatedTotal) * rate) then for each additional record calculate as (Hours * Rate).
Any know how to do this?
Thanks for the help as I have 12 hours into this silly report so far.
IP Logged