Forum Discussion
Anonymous
3 years agoNot applicable
add measured /calculated value in matrix row
Hi, i have an export of financial data (journal entries). Based on the GL account i have dfined a higher hiearchy level. I allready created a mapping table that contains all the GL accounts with ...
Anonymous
3 years agoNot applicable
update:
calculating the the total amounts based on reference number have worked.
but when i make an active realtion between tables the calculations for reference 3,6,9 disappear
no relation
no relation
active relation
syntax of calculation
Actuals YTD =
IF('calculations'[reference number]=1;
CALCULATE(SUM('Journal Entries'[total amount]);Mapping[reference number]=1);
IF('calculations'[reference number]=2;
CALCULATE(SUM('Journal Entries'[total amount]);Mapping[reference number]=2);
IF('calculations'[reference number]=4;
CALCULATE(SUM('Journal Entries'[total amount]);Mapping[reference number]=4);
IF('calculations'[reference number]=5;
CALCULATE(SUM('Journal Entries'[total amount]);Mapping[reference number]=5);
IF('calculations'[reference number]=7;
CALCULATE(SUM('Journal Entries'[total amount]);Mapping[reference number]=7);
IF('calculations'[reference number]=8;
CALCULATE(SUM('Journal Entries'[total amount]);Mapping[reference number]=8);
IF('calculations'[reference number]=3;
CALCULATE(SUM('Journal Entries'[total amount]);Mapping[reference number]=1)
-
CALCULATE(SUM('Journal Entries'[total amount]);Mapping[reference number]=2);
IF('calculations'[reference number]=6;
CALCULATE(SUM('Journal Entries'[total amount]);Mapping[reference number]=1)
-
CALCULATE(SUM('Journal Entries'[total amount]);
OR(OR(Mapping[reference number]=2;Mapping[reference number]=4);Mapping[reference number]=5));
IF('calculations'[reference number]=9;
CALCULATE(SUM('Journal Entries'[total amount]);Mapping[reference number]=1)
-
CALCULATE(SUM('Journal Entries'[total amount]);
OR(OR(OR(OR(
Mapping[reference number]=2;
Mapping[reference number]=4);
Mapping[reference number]=5);
Mapping[reference number]=7);
Mapping[reference number]=8));
0)))))))))
- Anonymous3 years agoNot applicable
amitchandak
maybe this info will be helpfull to further understand the situation