Ability to use a formula on a specified column on a crosstab 1

[n2nuk]

Hi there,

I am attempting to report on outcomes from a client interview, the front-end allows workers to select multiple values using a check box. the values are stored in the database as a text field concatenated by a $, for example
Advice given$Escalate to Intensive Service
Signposted$Advice given$Escalated to Health Services
Advice given$Escalate to Intensive Service
Signposted$Referral to another organisation$Advice given
Advice given$Escalate to Intensive Service
Assistance with form filling
Signposted$Advice given
Signposted$Advice given$Escalated to Health Services
Advice given$Assistance with form filling

On my column listing i am using a formula to strip out the values, foe example
InStr(( {events.outcome} ), 'Advice given' ) > 0
InStr(( {events.outcome} ), 'Signposted' ) > 0

I would like to produce a crosstab that counts the number of number of events by outcome. i am using using specified order but i am not able to use my formula to filter out the outcomes from the text file.

Any ideas how i can get around this?

Many thanks

 

[lbass]

Create a manual crosstab in the report footer.

Create formulas like this and place in the detail section:

If instr({events.outcome}),’Advice Given’)>0 then 1

Insert a sum on this at the report total level, and then move it next to a label “Advice Given: ” in the report footer. Repeat for other text alternatives.

-LB

 

[n2nuk]

Many thanks Lbass,

worked just i wanted it to.

Thanks again