I have a written a query which asks for the results of a couple of aggregate calculations:
count(*) as nTotal,
SUM(nTVC) as nVTotal
Results nTotal = 4754
nvTotal = 11911
However, when I add this line to the query:
count(*)/SUM(nTVC) AS nVPercent
Results nTotal = 4754
nVTotal = 11911
nVPercent = 0
What am I doing wrong?
count(*) as nTotal,
SUM(nTVC) as nVTotal
Results nTotal = 4754
nvTotal = 11911
However, when I add this line to the query:
count(*)/SUM(nTVC) AS nVPercent
Results nTotal = 4754
nVTotal = 11911
nVPercent = 0
What am I doing wrong?