Formulas and Queries

[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 ratioHere 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

[orange]

You might try showing us some samples of what you are dealing with.
What you have provided may make perfect sense to you, but I'm afraid it is pure jargon to most readers.

You have to realize that readers are from many backgrounds, countries, experiences etc, so start by telling us about you and your issue/opportunity in plain English.

You could tell us about the table containing columns Centre.

Googling Capacity of a Centre doesn't help.

[ItsMe]

Here is a list of common built in functions.
https://msdn.microsoft.com/en-us/lib.../ff823033.aspx