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 ,

 

Turn on ROW SUBTOTALS as shown below:

 

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

I have turned that on, but it still does not total month over month, it returns the same value.

  • 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.