Good Morning,
as part of an item performance review, I wanted to include the number of months where there were usage hits for an item.
I used the following:
=NL("Count","Item Usage","Usage Hits","Item No.",$D12,"Location Code",$E$3,"Starting Date",$F$5,"Usage Hits",">0")
in this case
$D12 has the item number
$E$3 has the location code being reviewed
$F$5 has a date range 09/01/2011..08/31/2012
However, using this function, the result is not as expected. It returns 12 for each item that has twelve period records in the item usage table. if the item has fewer records in the item usage table, the number will match that.
Any ideas are appreciated.
Regards,
Nicolai
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi Nicolai,
So I guess I'm not exactly sure how your Item Usage table works or what exactly your function is returning to you. You said it is not behaving as expected, but what exactly is it doing? Your description sounds like it is doing what you want, so I'm a little confused. What does the data in the Item Usage table look like exactly? Maybe you need to be using NL(CountUnique) instead of NL(Count)?
Regards,
Hughes -
Jet Reports Historic Posts the item usage table shows as simple example the following:
period start usage hits
01/01/2012 0
02/01/2012 1
03/01/2012 0
04/01/2012 0
05/01/2012 0
06/01/2012 0
07/01/2012 0
08/01/2012 0
I want to count the number of months where the usage hits were greater than 0. My desired result for the above example is 1. However, the function I am using would in this case return 8. -
Jet Reports Historic Posts Nicolai,
If the Usage Hits is always either 0 or 1, could you just use an NL(Sum) formula to sum the usage hits for the specified time frame? Maybe something like this:=NL("Sum","Item Usage","Usage Hits","Item No.",$D12,"Location Code",$E$3,"Starting Date",$F$5)
Does that help?
Regards,
Hughes -
Jet Reports Historic Posts I did find there may be an issue with a table.
We are researching that.
Thank you!
Please sign in to leave a comment.