Joined: 06 Aug 2009
Online Status: Offline
Posts: 12
Topic: count needed for a formula with 'maximum' in it Posted: 20 May 2011 at 7:19am
I have a formula field to calculate the days between order taken and last time it was sent for closure. There are several dates for closure and only the last one in the table is relevant so the formula is:
then I want:
2) total closed in given time range - can be down on report itself
3) count of days < 20 and the percentage of total
4) count of days > 20 and < 50 and the percentage of total
When I try to use the formula with maximum I am unable to do a count. What can I do to calculate #3 and # 4 above.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum