Forum Discussion

tedbuny's avatar
tedbuny
Frequent Visitor
2 years ago
Solved

Syntax Error When Using Divide Function

I'm trying to create a new measure that calculates the estimated number of cases deliveried using the DIVIDE function, however I continual receive the same error message regardless the syntax I use. ...
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    tedbuny Try wrapping it with an aggregator:

    Est.Cases = DIVIDE('Actual Sales'[Qty], 'MAX(Product Detail'[Units per Case]) )

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

tedbuny Try wrapping it with an aggregator:

Est.Cases = DIVIDE('Actual Sales'[Qty], 'MAX(Product Detail'[Units per Case]) )