Forum Discussion
divison calculation for the same column
Each dealer has four types of contracts they can sell. grouped as OL/CH and HP/FL I need to calc the percentage of all their deals which are OL/CH and HP/FL How can this be done? Other colu...
almost solved the issue
So I am using the fact table to get the figures but the details for the managers are coming from a connecting table as i need to use two table for a differernt calculation
therefore, if i add the manager details from the same table it works but if i use the connecting table it does not work.
but that means the other calculation i need will not work so either way there is an issue
What can i di to make both work or use the connecting table
Also changed formula to this =
HP/FL 2 = CALCULATE(SUM(Detail[Amount Financed]), FILTER(Detail,Detail[Doc Type] IN {"Hire Purchase", "Finance Lease"}))
HP/FL 2 = CALCULATE(SUM(Detail[Amount Financed]), FILTER(Detail,Detail[Doc Type] IN {"Hire Purchase", "Finance Lease"}))
CH/OL 3 = CALCULATE(SUM(Detail[Amount Financed]), FILTER(Detail,Detail[Doc Type] IN {"Contract Hire", "Operating Lease"}))