Newbies heyarn Posted September 8, 2006 Newbies Share Posted September 8, 2006 hi, please help me.. i need to be able to create a calculation that counts the number of different items purchased.. the count function doesn't work since it counts the number of items purchased and not the different types of items (based on item number).. Can someone please help? Thanks!! Link to comment Share on other sites More sharing options...
sal88 Posted September 11, 2006 Share Posted September 11, 2006 so if you had the following items based on item number: 1 1 3 4 5 5 then you would want the value to return 4? Link to comment Share on other sites More sharing options...
Newbies heyarn Posted September 12, 2006 Author Newbies Share Posted September 12, 2006 Hi, I appreciate your reply.. that is correct.. I need to ba able to count the number of unique items in the list : Link to comment Share on other sites More sharing options...
sbg2 Posted September 13, 2006 Share Posted September 13, 2006 Create a Value List from the items and use the ValueCount and ValueListtems functions to get the count. Example at theis link- http://fmforums.com/forum/showtopic.php?tid/180284/ Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6598 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now