Forum Discussion

CMSGuy's avatar
CMSGuy
Icon for Helper III rankHelper III
4 years ago
Solved

Cumulate Remainer formula help needed

I think this is pretty simple but I need help with a cumulative remainder total.  The table has a column, T1N which is total needed, then T1S is total submitted, then T1R is remainder.  This view is ...
Need Help
  • daXtreme's avatar
    daXtreme
    4 years ago

    CMSGuy 

     

    Are these Txx measures or columns from the base table? If they are measures, then I guess it's enough to turn them into: T1N = SUM( T[RelevantColumn] ). Same for T1S and then T1R will be the diff of the measures.

daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
4 years ago

CMSGuy 

 

Are these Txx measures or columns from the base table? If they are measures, then I guess it's enough to turn them into: T1N = SUM( T[RelevantColumn] ). Same for T1S and then T1R will be the diff of the measures.

  • CMSGuy's avatar
    CMSGuy
    Icon for Helper III rankHelper III
    4 years ago

    They are coming from the base table.  Should they be measures?