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'
