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!

AntrikshSharma's avatar
AntrikshSharma
Community Champion
6 years ago
The ultimate goal is to make sure the user's query is resolved, language is just a bridge to ensure that communication is done properly, if a group of people decide that the new synonym is unfreezed soon it will be accepted worldwide, I have studied English since first day at school, but still it is impossible to remember tense for each word, when I come online I try to solve 5-10 questions and in that time frame I can't pay heed to my English. I am sure the OP understood what I meant by unfreezed 🙂
Anonymous's avatar
Anonymous
Not applicable
6 years ago
Interestingly, I have not studied English since my first day at school but I almost always get it right (without paying any heed to it as I type) and solve not fewer problems than you. But I really don't have time to enlarge upon why proper English is a good-to-have skill. You do as you please.

Best
D