Forum Discussion

jeoosma's avatar
jeoosma
Helper II
8 years ago
Solved

Format number

Hi. How can I modify the format in the grapf? Atoumatically it is in currency but in the query the number is decimal and in the graph is as average. I see in the format tile but I don't resolve the problem. Thank you for help.

 

  • Anonymous's avatar
    Anonymous
    8 years ago

    jeoosma,

    Do mask sensitive data before uploading screenshots.

    In your screnario, click on your field in the FIELDS panel, then under Modeling ribbon, you can change the format of the field from Currency to Decimal Number. There is an example for your reference.

    Regards,
    Lydia

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    The second screen shot is from the Query Editor. In the data model, the data type/format may be different because after they come into the model, you can change it. So, you do not want it in currency and you want something other than the average? Not sure what is incorrect.

  • Anonymous's avatar
    Anonymous
    Not applicable

    jeoosma,

    Do mask sensitive data before uploading screenshots.

    In your screnario, click on your field in the FIELDS panel, then under Modeling ribbon, you can change the format of the field from Currency to Decimal Number. There is an example for your reference.

    Regards,
    Lydia