Topic: need help with formula Posted: 04 Aug 2021 at 2:49am
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'
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 12 Aug 2021 at 10:44am
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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
