Calculating percentage

[Guest]

I am calculating a percentage from two queries that count data.
The first query calculates the total orders [Total].
The second query calculates the number of orders that failed to process
[Failed].

When my third query attempts to perform the percentage calculation:
FailedItems:[Failed]\[Total]

It returns wither 100% or 0%. As if it thinks that I am dealing with
integers or something. I can see examples where this works. Help! TIA.
Mike

 

[Allen Browne]

Backslash performs integer division.

Try:
FailedItems: [Failed] / [Total]

Of course, that will still error if Total is zero.

 

[Guest]

Thank you Allen! Perfect! (old C programming skills bleeding through...)

Backslash performs integer division.

Try:
FailedItems: [Failed] / [Total]

Of course, that will still error if Total is zero.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I am calculating a percentage from two queries that count data.
The first query calculates the total orders [Total].
The second query calculates the number of orders that failed to process
[Failed].

When my third query attempts to perform the percentage calculation:
FailedItems:[Failed]\[Total]

It returns wither 100% or 0%. As if it thinks that I am dealing with
integers or something. I can see examples where this works. Help! TIA.
Mike