I am trying to count the Aging for >= or < hour. When I tried using pivot table is counting correctly but when use as formula is not working.
Or is there any other formul to solve the greater or less than 1 hour?
Please refer to attachment. The sample formula is at column AP.
Regards
Chitra
Because 2 + 1 = 3? I'm not sure which records you believe should count and are not.
The formula appears to evaluate correctly.
First Forumula Half= True, True, False, False
Second Formula Half= False, False, True, False
The first three rows are counted, the fourth is not.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
The first seems to be correct
In the second you have used Resolaging2 instead of resolaging in both countifs
Also an extra blank space an extra space that is not in the table
=COUNTIFS(Table1[Workgroupsumm],$AP$10,Table1[ResolAging2],"<= 1 hour",Table1[Reported Date],"<="&$AP$8,Table1[Mth Cls],"Jun-15")+COUNTIFS(Table1[Workgroupsumm],$AP$10,Table1[ResolAging],"<= 1 hour",Table1[Reported Date],"<="&$AP$8,Table1[Mth Cls],"")
REgards
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
All the while I was using column "ResolAging" to count at heading "1 hour" but it did not work. Just to test the formula, I tested by adding ResolAging2 but that too did not work.
If I choose 1 hour, it should count as 4 records and if I choose "<= 1 hour", should count as 1 record.
Is there any other formula to solve this issue?
Is there any other formula to solve this issue? Really need your suggestions and expertise. Spent so much time solving this issue...
Last edited by suchetherrah; 06-04-2015 at 05:17 PM.
How are you calculating the aging?
It seems that there would be a much more efficient formula, such as sumproduct.
First formula is working because dates in column D contains time also but in AP8 time is 12:00
So 31/5/15 is excluded. Use 1/6/15 instead
See attached also
Use this as second formula
AS10:
It will calculate 1
Please Login or Register to view this content.
Regards
Last edited by mahju; 06-04-2015 at 10:04 PM.
Sorry for the delay for not replying this thread due to unforeseen curcumstances.
Thank you for your suggestion. daffodil11 did mention that to try sumproduct but I still couldn't get it right.
Please advise. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks