AnsweredAssumed Answered

Counting Occurences of Values in Dropdown List

Question asked by neilgalang on Jul 25, 2012
Latest reply on Aug 30, 2012 by philmodjunk

Title

Counting Occurences of Values in Dropdown List

Post

Hi,

 

I dont mean to be a baby, but this forum has been very helpful with my FM project-- I encountered another task, which is:

Counting Occurences of Values in Dropdown List

So basically I have a value list defined from a set of records named modalities (modalities are patient treatments)...these modalites are

 

1 HEAT

2 COLD

3 TENS

4 GROUP

 

Then I have ten fields on my PATIENT MODALITIES layout which contain these values in the each of the ten fields, per patient modality record....

I need a report or a summary that summarizes the

 

1) number of modalities each patient has gone through ie

 

Patient Rex Smith

 

HEAT - 4

COLD - 4

TENS - 0

 

and

 

2) Number of instances of this modality per found set ie

 

HEAT

235 sessions

COLD

125 sessions

GROUP

50 sessions

 

 

I think both processes are the same, its just a matter of sorting? I am having trouble and getting dizzy doing subsummary layouts....please help...thanks in advance gurus!

Outcomes