Sample Data

	A	B	E	F	G	H	I	J	O
1	PROJINVOICEJOUR		PROJTRANSPOSTING
2	PROJID	FAKTURERT	PROJID	AMOUNTMST	COSTSALES	CATEGORYID	ACCOUNT	POSTINGTYPE
3	PROJECT2-01	7 858	PROJECT1	−164000	2	I9999	3000	127
4	PROJECT2-01	36 750	PROJECT2-01	−14700	2	I9999	2903	138
5	PROJECT1	233 580	PROJECT2-01	−4200	2	I9999	2903	138
6	PROJECT2	2 850 000	PROJECT2-01	−10500	2	I9999	2903	138	VIA =
7	PROJECT1	1 186 220	PROJECT2	−2850000	2	I9999	2903	138	VAR _profit = CALCULATE(SUMX(PROJTRANSPOSTING,PROJTRANSPOSTING[AMOUNTMST]),PROJTRANSPOSTING[ACCOUNT]="2901",PROJTRANSPOSTING[DATAAREAID]="100",PROJTRANSPOSTING[CATEGORYID]="Profit")
8	PROJECT2	1 710 000	PROJECT2	−1710000	2	I9999	2903	138
9	PROJECT1	752 000	PROJECT2	−570000	2	I9999	2903	138	VAR _kost = CALCULATE(SUMX(PROJTRANSPOSTING,PROJTRANSPOSTING[AMOUNTMST]),PROJTRANSPOSTING[POSTINGTYPE]<>122,PROJTRANSPOSTING[COSTSALES]=1,PROJTRANSPOSTING[AMOUNTMST]<>.000000000000)
10	PROJECT2	570 000	PROJECT1	−1167900	2	I9999	3100	127
11	PROJECT1	164 000	PROJECT1	−13740	2	I9999	3100	127	VAR _fakturert = SUMX(PROJINVOICEJOUR,PROJINVOICEJOUR[FAKTURERT])
12	PROJECT1	164 000	PROJECT1	−4580	2	I9999	3100	127
13	PROJECT1	-164 000	PROJECT1	−687000	2	I9999	3100	127	return _fakturert-_kost-_profit
14	PROJECT2-01	14 700	PROJECT1	−229000	2	I9999	3100	127
15	PROJECT2-01	14 700	PROJECT1	164000	2	I9999	3100	127
16	PROJECT2-01	-14 700	PROJECT1	−164000	2	I9999	3100	127
17			PROJECT2	4125	1	3270	4910	121
18			PROJECT2	4125	1	3270	4910	121
19			PROJECT2	4125	1	3270	4910	121	Goals:
20			PROJECT2	126,5	1	3270	4910	121	My goals is to have two collumns in a visual table, where if the sum of VIA is below 0 (negative) it will show in one collumn, and if it is above 0 (positive) it will show in the other collumn.
21			PROJECT2	4125	1	3270	4910	121	These calculations needs to be done on every line, as the visual table will just show sum pr. project. This sample data only contains a few projects to keep it small
22			PROJECT2	676,5	1	3270	4910	121
23			PROJECT2	4125	1	3270	4910	121
24			PROJECT2	4125	1	3270	4910	121
25			PROJECT2	2475	1	3270	4910	121
26			PROJECT2	3525,5	1	3270	4910	121
27			PROJECT2	4125	1	3270	4910	121
28			PROJECT2	4125	1	3270	4910	121
29			PROJECT2	4125	1	3270	4910	121
30			PROJECT2	4125	1	3270	4910	121
31			PROJECT2	4125	1	3270	4910	121
32			PROJECT2	4125	1	3270	4910	121
33			PROJECT1	1029,86	1	V4300	4300	121
34			PROJECT1	448,94	1	V4300	4300	121
35			PROJECT1	224,47	1	V4300	4300	121
36			PROJECT1	3834	1	V4300	4300	121
37			PROJECT1	1110,9	1	V4300	4300	121
38			PROJECT1	1832,4	1	v9387	4300	121
39			PROJECT1	1303,68	1	v9387	4300	121
40			PROJECT1	112,22	1	v9387	4300	121
41			PROJECT1	971,47	1	v9387	4300	121
42			PROJECT1	2748,6	1	v9387	4300	121
43			PROJECT1	1920	1	v9387	4300	121
44			PROJECT2	650,76	1	v9387	4300	121
45			PROJECT2	513,22	1	v9387	4300	121
46			PROJECT2	92	1	v9387	4300	121
47			PROJECT2	158	1	v9387	4300	121
48			PROJECT2	4100	1	v9387	4300	121
49			PROJECT2	2880	1	v9387	4300	121
50			PROJECT2	4100	1	v9387	4300	121
51			PROJECT2	232	1	v9387	4300	121
52			PROJECT2	2880	1	v9387	4300	121
53			PROJECT2	717,96	1	v9387	4300	121
54			PROJECT2	538,47	1	v9387	4300	121
55			PROJECT2	119,19	1	v9387	4300	121
56			PROJECT2	85,73	1	v9387	4300	121
57			PROJECT2	537,42	1	v9387	4300	121
58			PROJECT2	280,56	1	v9387	4300	121
59			PROJECT2	3063,2	1	v9387	4300	121
60			PROJECT2	3513,6	1	v9387	4300	121
61			PROJECT2	56,11	1	v9387	4300	121
62			PROJECT2	656,4	1	v9387	4300	121
63			PROJECT2	297,57	1	v9387	4300	121
64			PROJECT2	112,77	1	v9387	4300	121
65			PROJECT2	109,4	1	v9387	4300	121
66			PROJECT2	42,08	1	v9387	4300	121
67			PROJECT2	437,6	1	v9387	4300	121
68			PROJECT2	292,8	1	v9387	4300	121
69			PROJECT2	1790	1	v9387	4300	121
70			PROJECT2	314,18	1	v9387	4300	121
71			PROJECT2	2880	1	v9387	4300	121
72			PROJECT1	196,08	1	v9385	4300	121
73			PROJECT1	497,59	1	v9385	4300	121
74			PROJECT1	248,79	1	v9385	4300	121
75			PROJECT1	414,66	1	v9385	4300	121
76			PROJECT1	761,43	1	v9385	4300	121
77			PROJECT1	553,77	1	v9385	4300	121
78			PROJECT1	151,15	1	v9385	4300	121
79			PROJECT1	703,5	1	v9385	4300	121
80			PROJECT1	948,2	1	v9385	4300	121
81			PROJECT1	229,9	1	v9385	4300	121
82			PROJECT1	567,75	1	v9385	4300	121
83			PROJECT1	198	1	v9385	4300	121
84			PROJECT1	378,49	1	v9385	4300	121
85			PROJECT1	348,13	1	v9385	4300	121
86			PROJECT1	348,13	1	v9385	4300	121
87			PROJECT1	948,2	1	v9385	4300	121
88			PROJECT1	1374,3	1	v9385	4300	121
89			PROJECT1	7470,58	1	v9385	4300	121
90			PROJECT1	125,55	1	v9385	4300	121
91			PROJECT1	387,9	1	v9385	4300	121
92			PROJECT1	5768,4	1	v9385	4300	121
93			PROJECT1	4612,7	1	v9385	4300	121
94			PROJECT1	378,49	1	v9385	4300	121
95			PROJECT1	348,13	1	v9385	4300	121
96			PROJECT1	348,13	1	v9385	4300	121
97			PROJECT1	1101,06	1	v9385	4300	121
98			PROJECT1	7470,58	1	v9385	4300	121
99			PROJECT1	25234,5	1	v9385	4300	121
100			PROJECT1	290,26	1	v9385	4300	121