Add Calculate field in Table report

[peewan]

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,
   

[Francis aka khayman]

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...

[peewan]

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"

[Francis aka khayman]

can you show us the columns for both tables/queries?