Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 07 Nov 2016 at 2:42am
create 3 Running Totals, each with an evaluate formula using a instring or like condition.
example:
RT name = VisionCount
Field to Summarize = PK as a counter or the Question
Type of summary = Count (distinct count if duplicates need to be handled and you can use the appropriate PK)
Evaluate= use a formula
table.answer like '*vision*'
reset = never (unless you need group values)
Field to evaluate = PK or the question field
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum