Forum Discussion

Lazurens's avatar
Lazurens
Frequent Visitor
3 years ago
Solved

Divide retruns incorrect result

Hello, 

I have a problem getting the correct division result of this example

Correct Result : DIVIDE(203040543.9, 9830033.751) = 20.66 
When I try the divide operation by itself with these numbers I get 20.66, but when I use the variables I get incorrect result (0.19) ! 
Here is the formulae 
Productivity = 

VAR T1 = SUMX('FACT_PRODUCT_MANUFACTURING', 'FACT_PRODUCT_MANUFACTURING'[TOTAL_QTY] * 'FACT_PRODUCT_MANUFACTURING'[CONVERSION_FACTOR])
VAR T2 = DIVIDE(SUMX('FACT_PRODUCT_MANUFACTURING', 'FACT_PRODUCT_MANUFACTURING'[OPENING_TIME]), 3600)
VAR T3 = SUMX('FACT_PRODUCT_MANUFACTURING', 'FACT_PRODUCT_MANUFACTURING'[REAL_WORK_FORCE])
VAR T4 = DIVIDE(T1, T2 * T3)

RETURN T4

The visualisation will be listed in year_month and the calendar is connected with a cardinality of 1 to many filtering on the Fact table.
Any help will be appreciated, and many thanks in advance.
Regards,

  • Lazurens's avatar
    Lazurens
    3 years ago

    I somehow made it work this way : 

    Productivity = 
VAR T1 =
    CALCULATE (
        SUMX (
            'FACT_PRODUCT_MANUFACTURING',
            'FACT_PRODUCT_MANUFACTURING'[TOTAL_QTY] * 'FACT_PRODUCT_MANUFACTURING'[CONVERSION_FACTOR]
        )
            / SUMX (
                'FACT_PRODUCT_MANUFACTURING',
                ( 'FACT_PRODUCT_MANUFACTURING'[OPENING_TIME] / 3600 ) * 'FACT_PRODUCT_MANUFACTURING'[REAL_WORK_FORCE]
            )
    )
RETURN
    T1

1 Reply

  • Lazurens's avatar
    Lazurens
    Frequent Visitor
    3 years ago

    I somehow made it work this way : 

    Productivity = 
VAR T1 =
    CALCULATE (
        SUMX (
            'FACT_PRODUCT_MANUFACTURING',
            'FACT_PRODUCT_MANUFACTURING'[TOTAL_QTY] * 'FACT_PRODUCT_MANUFACTURING'[CONVERSION_FACTOR]
        )
            / SUMX (
                'FACT_PRODUCT_MANUFACTURING',
                ( 'FACT_PRODUCT_MANUFACTURING'[OPENING_TIME] / 3600 ) * 'FACT_PRODUCT_MANUFACTURING'[REAL_WORK_FORCE]
            )
    )
RETURN
    T1