Forum Discussion

BlackCat's avatar
BlackCat
Icon for Helper III rankHelper III
5 years ago
Solved

Can't change decimal in format

I am trying to change the decimal in one of my columns, I've highlighted that it should read 10,416.67 but instead as you can see in my attachment is reading $1,041.667. I've tried to change the deci...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi BlackCat ,

     

    It looks like you want to divide this value further by 100 to get that format. Is it right?

    Something like below:

     

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi BlackCat ,

 

I think there is problem with your measure calculation. It shows same value for every month. See the screesnhot below as highlighted:

Check relationships between the tables from where the fields are moved in this visual.

 

BlackCat's avatar
BlackCat
Icon for Helper III rankHelper III
5 years ago

This calculation is for "weighted"

Weighted contract/mo = DIVIDE('Deal'[weighted total contract],MAX('Deal'[Contract Duration in Months]))
It is a month over month but should be able to total at the end of the row or column, it does in my standard report
  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    5 years ago

    Hi BlackCat ,

     

    But I can't see your calculation chnaging month-wise in the matrix visual that you have created.

    The reason is the MONTH-YEAR column in this visual comes from a different table which hasn't got any relationship with your DEAL table.

     

    Check this at your end. You will understand what I am trying to say.

     

    Also create a new thread for this issue just that it is easier for others to locate right solutions to the respective threads.

    Tag me once you create a new thread.