Exponent Value changes to 0

NickHoff — Wed, 31 Dec 2014 17:31:21 GMT

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?

Re: Exponent Value changes to 0

Colin-Albert — Wed, 31 Dec 2014 18:09:22 GMT

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

Re: Exponent Value changes to 0

Anonymous — Wed, 31 Dec 2014 18:10:08 GMT

Hi!

Can you attach an example qvw application?

topic Exponent Value changes to 0 in QlikView

Exponent Value changes to 0

Re: Exponent Value changes to 0

Re: Exponent Value changes to 0