Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Decimals in Measure

I'm using a table called "IV Data". I have a column named "CallfilevisitID" and one that is a key column that combines "Username" and "InterventionDate".  I've created a measure to distinct count my...
Need Help
  • Cmcmahan's avatar
    Cmcmahan
    7 years ago

    Very possible.  In the Fields pane to the right, select the measure in question.

     

    In the Modeling ribbon at the top, there are options for formatting the field.  Make sure the data type is a decimal number, and then you can select a number of decimal places to show. Change it from Auto to 2.

Cmcmahan's avatar
Cmcmahan
Resident Rockstar
7 years ago

Very possible.  In the Fields pane to the right, select the measure in question.

 

In the Modeling ribbon at the top, there are options for formatting the field.  Make sure the data type is a decimal number, and then you can select a number of decimal places to show. Change it from Auto to 2.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I figured out what I was doing wrong.....

I tried to change the number format, but it never gave me the option to change it. 

Figured out that I had the card selected, and not actually the measure under fields. 

 

Thanks for your help!