|
I have a Frequency from a document with formula of
If {DimDiscipline.DisciplineKey}=1 and
{DimDocumentType.DocumentType_ID}=1 then {DimTreatmentPlan.TxFrequencyLow}
ELSE
If {DimDiscipline.DisciplineKey}=2 and
{DimDocumentType.DocumentType_ID}=1 then {DimTreatmentPlan.TxFrequencyLow}
ELSE
If {DimDiscipline.DisciplineKey}=3 and
{DimDocumentType.DocumentType_ID}=1 then {DimTreatmentPlan.TxFrequencyLow}
This works correctly and pulls the frequency patient should be seen weekly. Then I have a formula for Week 1, Week 2 etc., that counts up to 7 days for each week beginning with a start date the 1st time patient was seen.
To Count the number of times seen in a week I created a @value formula of Whileprinting records; Numbervar sum; This also works.
Now I need each weeks total visits to be compared with the Frequency and I can't make it work. Example: if frequency is 5 and Week # >= 5 then 'Met' else 'Review'
|
|
In the general overview, what I would do is use Shared Variables to set the values for each of the weekly counts, both the summary and the detail.
Now you can create formulas to compare the Shared Variables and report out the findings.
Hopefully this is helpful, as opposed to being obvious. Without knowing the details of your data or the various formulas already in use, it is hard to offer anything more solid.
|
IP Logged
