Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
CH/OL% = DIVIDE(SUM('Key Measures'[CH/OL],SUM('Key Measures'[CH/OL])+SUM('Key Measures'[1 HP/FL]),0))
 
Why does this calculation not work for me? it wont pick up the table that the columns are in
also this message comes up
 
Too many arguments were passed to the SUM function. The maximum argument count for the function is 1.
Anonymous's avatar
Anonymous
Not applicable
5 years ago
CH/OL = CALCULATE(SUM('Detail'[Amount Financed]),'detail'[doc type]<>"Operating Lease",'detail'[Doc type]<>"Contract Hire")
 
Im using this but its not actually picking up the data correctly 
What is wrong with the calculation
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Try 

    CH/OL = CALCULATE(SUM('Detail'[Amount Financed]),FILTER('Detail','Detail'[doc type]<>"Operating Lease" && 'Detail'[Doc type]<>"Contract Hire"))

     

    If you want to remove other filters, add the ALL/ALLSELECTED function

    CH/OL = CALCULATE(SUM('Detail'[Amount Financed]),FILTER(ALL('Detail'),'Detail'[doc type]<>"Operating Lease" && 'Detail'[Doc type]<>"Contract Hire"))

    or

    CH/OL = CALCULATE(SUM('Detail'[Amount Financed]),FILTER(ALLSELECTED('Detail'),'Detail'[doc type]<>"Operating Lease" && 'Detail'[Doc type]<>"Contract Hire"))

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      This is still not picking up the data correctly 

       

      Is there any other explanation for why it may not work?

       

      The calculation method for the rest of the process is correct but its the first calculation which is the issue which means the results for the rest of the process are an issue 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago
      Step 1: calculations are diff tried two but give same results but this is the issue as data is not being picked up correctly 
      CH/OL = CALCULATE(SUM('Detail'[Amount Financed]),FILTER('Detail','Detail'[doc type]<>"Operating Lease" && 'Detail'[Doc type]<>"Contract Hire"))
      1 HP/FL = CALCULATE(SUM('Detail'[Amount Financed]),'detail'[doc type]<>"Hire Purchase",'detail'[Doc type]<>"Finance Lease")
       
      step 2:
      CH/OL plus 1 HP/FL =
      [CH/OL] + [1 HP/FL]
       
      Step 3:
      CH/OL% = Divide ('Key Measures'[CH/OL],'Key Measures'[CH/OL plus 1 HP/FL],0)
      HP/FL% = Divide ('Key Measures'[1 HP/FL], 'Key Measures'[CH/OL plus 1 HP/FL],0)
       
      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Just a thought but could it be <> in the formula as I need it to add up amount financed values for all of the CH and OL