Hi Friends,
I'm doing the report page by using table, singleton, and i want to add calculate the value between to column in the table.
My table like this:
Age ED visit Total Months Visit per 100 month
<1 <Total <1> <Total month <1>
1-5 <Total 1-5> <Total month 1-5>
6-10 <Total 6-10> <Total month 6-10>
Table with 4 columns, and 4 rows
Age: in text
ED Visit: using singleton in every single row
Total Months: using singleton in every single row also
ED visit located in ED Table/Query
Total Month Located in Benifit Table/Query
would like to calculate Visit per 100 month:
Visit per 100 month = (ED\Total Month)*100
I tried to use Layout calculate, but it didn't work.
Thank you,
i know i am pointing out the obvious here but...
if you have a normal query then you can easily calculate ED\Total Months
but for some reason you have to use singletons (normal query too easy perhaps?) so...
Quote from: Francis aka khayman on 10 Oct 2019 12:17:50 PM
i know i am pointing out the obvious here but...
if you have a normal query then you can easily calculate ED\Total Months
but for some reason you have to use singletons (normal query too easy perhaps?) so...
Hi,
As I mention above, they are from 2 difference queries.
"ED Visit: using singleton in every single row
Total Months: using singleton in every single row also
ED visit located in ED Table/Query
Total Month Located in Benifit Table/Query"
can you show us the columns for both tables/queries?