Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to load calculated 'Facts' when you are loading a table. I have a table with the following fields and records:
[Drug Name] and [Repeat or Original]
Frusemide Original
Frusemide Repeat
Frusemide Original
Frusemide Original
Frusemide Original
Frusemide Repeat
Amlodipine Original
Amlodipine Original
Amlodipine Original
Amlodipine Repeat
Amlodipine Repeat
Amlodipine Original
i want to be able to load calculated fields based on the above records as follows:
if this is not possible, what is the alternative approach?
I hope my question is clear. Thanking you in advance.
Regards
Chris
Hello
Many thanks, if i select current month in the calendar it is returning the correct TRx count but this value is the same as the year to date value calculated as follows:
Sum({$<$(vSetYTD)>} Aggr(TextCount([Repeat or Original]), [Drug Code]))
I do not know what is going on.
regards.
Chris
It will be great if you could post a sample file with expected numbers. That will help me and other members to give you prompt responses.
--Singh
Hello Singh
I managed to figure it out. I changed it to the following and it is now working:
Sum(Aggr(Count({$<$(vSetYTD)>} [Repeat or Original]), [Drug Code]))
Regards
Chris
Great! Feel free to mark any answer as helpful or correct to close the thread.
Thanks,
Singh