Forum Discussion

arniet's avatar
arniet
Frequent Visitor
6 years ago
Solved

Formatting issues

  Hi, when creating a measure, some instances I am unable to have the option to select the format of my measure, in particular, I want to have zero decimal places as shown below. Is it because the n...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi arniet ,

     

     

    You are trying to return an integer and a string value in the same Measure.

     

    Try Like this measure

     

    Net Sales per order = Divide ( [MTD Curr [Net Sales] , [MTD Curr] , BLANK())

     


    Regards,

    Harsh Nathani


    Appreciate with a Kudos!! (Click the Thumbs Up Button)


    Did I answer your question? Mark my post as a solution!