Forum Discussion
Solved
[Solved] Issues with creating a single table with multiple constraints
Solution OPSTAT Retail Income =
IF(
MAX(dimensionValues[Department Number]) = "155",
CALCULATE(
SUM(generalLedgerEntries[amount]) * -1,
REMOVEFILTERS(dimensionValues[Depart...
Hi,
This calculated column formula works
Column = if(AND(1*Data[Department]>=11,1*Data[Department]<=17),Data[Sum accounts 4700-4705],SUM(Data[Sum accounts 4740 - 4741]))Hope this helps.
| Department | Sum accounts 4700-4705 | Sum accounts 4740 - 4741 | Expected Output |
011 | 200 | 15 | 200 |
| 013 | 300 | 10 | 300 |
| 014 | 300 | 20 | 300 |
| 015 | 250 | 25 | 250 |
| 017 | 150 | 10 | 150 |
| 155 | 580 | 660 |
Above is sample data to illustrate what I am trying to achieve. The expected output consists of departments 011-154 containing their respective total sum of accounts 4700-4705, while for department 155, I want to sum the entire column of accounts 4740-4741 and have it displayed on department 155.
660 in this example is the sum of all the accounts 4740-4741 inclusive of department 155's value where as all the other values are just the sum of the accounts 4700-4705.
Hi,
This calculated column formula works
Column = if(AND(1*Data[Department]>=11,1*Data[Department]<=17),Data[Sum accounts 4700-4705],SUM(Data[Sum accounts 4740 - 4741]))Hope this helps.