Query Table formulas

[aparnawangu]

Hi Team,
I have a Query table containing columns Centre,Capacity of a Centre that is a fixed value,Strength of a centre that will change every week,Then i require sum of Capacity and strength column.
Now i need to calculate Availabity per centre of seats and Conversion ratio:banghead:Here only problem arrives.
Availability:Capacity-Strength
Conversion ratio:Total Strength/Total Capacity*100
I need the formulas how to write them in a proper manner so that the error will not come.



Thanks
Aparna

 

[GinaWhipp]

What error? You mean when the field is NULL? Have you tired...

Conversion ratio: (Nz([Total Strength],0)/Nz([Total Capacity],0))*100

Not quite sure I got that right as it was unclear if the entire formula was to multiply by 100 or just Total Capacity.