How can I make a column that contains “1” (number format) for every category row in a column from a certain view?Then I need this column to be “totaled” to get the sum of all categories.
Please help!
P.S. If this is not possible - please suggest other way of doing it!
Subject: Counting categories in a column (@formula way)
You can count them using formula…
categories := @Trim( @Unique( @DbColumn( “”:“NoCache”; @DbName; “PUT_YOUR_VIEW_NAME_HERE”; PUT_YOUR_COLUMN_NUMBER_HERE ) ) );
number_of_categories := @Elements( categories );
Hope this helps,
Craig.
Subject: RE: Counting categories in a column (@formula way)
It’s not working… 
Probably it’s about this “special text” type.
Does anybody have some other suggestions?
Subject: RE: Counting categories in a column (@formula way)
What “special text”? Just use the catgorised column – the category value can’t be “special text” (@DocNumber, etc.). No need to create a special column just to count the categories.