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:

     

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

If you look at my last column subtotals they are returning the value of each column and not the total month over month. For instance The Division Learning should be totaling the entire row.

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.