Forum Discussion

Rena's avatar
Rena
Resolver II
1 year ago
Solved

Total Not Actually Adding - already using SUMX/VALUES

Here is my problem.  I am trying to get an estimated annualized number.  I have the YTD Volume, and the Volume Remaining for the rest of the year.  Dividing these gives me the volume factor (so I can...
Need Help
  • Rena's avatar
    Rena
    1 year ago

    I probably did this the longest way possible, but it works!  I went through and created a new table that simply had the plant name in one column.  Then I added 3 columns - Volume YTD using the same formula I had for measure, Volume Remaining using the same formula as the measure, and Volume Factor using the same formula for the measure I already had.

     

    Then I changed my measure to this and it worked.

     

     

     

hnguy71's avatar
hnguy71
Super User
1 year ago

Do you have sample data that you can share that I can recreate on my end? If you can anonymize the data and share that would be great.

Rena's avatar
Rena
Resolver II
1 year ago

I probably did this the longest way possible, but it works!  I went through and created a new table that simply had the plant name in one column.  Then I added 3 columns - Volume YTD using the same formula I had for measure, Volume Remaining using the same formula as the measure, and Volume Factor using the same formula for the measure I already had.

 

Then I changed my measure to this and it worked.