HELLLP!! counting the types of items purchased

[heyarn]

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!!

[sal88]

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?

[heyarn]

Hi,

I appreciate your reply.. that is correct.. I need to ba able to count the number of unique items in the list :

[sbg2]

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/