Exponent Value changes to 0

[NickHoff]

I'm having issues with an expression value displaying correctly as an expression, but with several additional digits and the exponent.

I have a variable defined as eTotalCases:

=SUM({1<DivisionName={$(vDivisionSelections)},Facility={$(vFacilitySelections)},SubUnit={$(vSubUnitSelections)},MonthID={$(vMonthIDSelections)}>}@CoidSummaryCases)

I have an expression for Mortality Cases defined as:

=SUM({$<DischargeStatusCode = {'40','41','42'}>}Cases)

Then the expression which is causing the formating issue:

=[Mortality Cases]/eTotalCases

I've attempted to add =NUM(expression) ,'#,##0') to each of the expressions and added to the variable.  Also, i've attempted to add =NUM(NUM#(Expression),'#,##0')

But, nothing is working.  Soon as I change the number format with precision of 2 it displays as an exponent, if I use fixed decimal it will display as a 0.00.

Has anyone ran into this issue and if so what was the fix?

[Colin-Albert]

Can you display [Mortality Cases] and TotalCases separately to test those values are correct, and what they value of the division would be?

[Anonymous]

Hi!

Can you attach an example qvw application?