Hi Brenda,
1. Create a formula called "@Falls" with this code:
If Instr({Class field}, "Fall") > 0 then 1
2. Similarly, create a separate formula for each value. The formula for infection would look like this:
If Instr({Class field}, "Infection") > 0 then 1
3. You should now be able to add these formula fields to a chart (set its sum function to "sum").
-Abhilash
Thanks so much for replying Abhilash,
If I create separate formulas then I won't be able to chart "Classifications" as one . The attached example is what I am trying to achieve. Each classification has a rating, hence the stacking. So the 'on change of' option in charts should be Classification and Rating, with the sum or count of Classification in 'show value'. Am I missing something fundamental?
thanks again, very much appreciated.
Cheers
Brenda
Split() function should return values you want
@Classification
Split(yourfield, "<br>")[2]
Ian
Add comment