China
CN
+86
India
IN
+91
United States
US
+1
Indonesia
ID
+62
Brazil
BR
+55
Pakistan
PK
+92
Nigeria
NG
+234
Bangladesh
BD
+880
Russia
RU
+7
Mexico
MX
+52
[Country] = "Brazil"
Simple
=
Country
True
fixed
2019-09-09 09:50:32
0
Brazil
2019-09-09 09:50:32
2019-09-09 09:50:32
[Country] = "Brazil"
4390
Ned Lanning
Marketing
8604
Margo Hendrix
Sales
8389
Dianne Pugh
Finance
4937
Earlene McCarty
Accounting
8299
Mia Arnold
Operations
2643
Jorge Fellows
Executive
5243
Rose Winters
Sales
9693
Carmela Hahn
Finance
1636
Delia Cochran
Accounting
6703
Marguerite Cervantes
Marketing
[Emp ID] = 8389
Simple
=
Emp ID
True
fixed
2019-09-09 09:57:22
0
8389
2019-09-09 09:57:22
2019-09-09 09:57:22
[Emp ID] = 8389
10%
9700
24%
84200
22%
39475
35%
204100
32%
160726
37%
510300
[Max Income] >= 46523
Simple
>=
Max Income
True
fixed
2019-09-09 14:24:01
0
46523
2019-09-09 14:24:01
2019-09-09 14:24:01
[Max Income] >= 46523
Max Income - Ascending
First
1
First 1
Total sales
50000
78200
89500
91250
308950
Cost of sales
-25000
-42050
-59450
-60450
-186950
Gross profit
25000
36150
30050
3080
122000
Depreciation
-899
-791
-202
-412
-2304
Interest
-513
-853
-150
-956
-2472
Earnings before Tax
23588
34506
29698
29432
117224
Tax
-4246
-6211
-5346
-5298
-21000
Net profit
19342
28295
24352
24134
96124
Profit %
29.3%
27.8%
23.4%
27.6%
26.9%
[Income Statement] = "Gross profit"
Simple
=
Income Statement
True
fixed
2019-09-09 14:36:18
0
Gross profit
2019-09-09 14:36:18
2019-09-09 14:36:18
[Income Statement] = "Gross profit"
Apple
23
.52
11.90
Grape
98
.77
75.28
Pear
75
.24
18.16
Banana
95
.18
17.25
Cherry
42
.16
6.80
Product
include
Int32
4
Empty
IF [Product]='Grape' THEN 1
ELSEIF [Row-1:Product]='Banana' THEN 0
ELSE [Row-1:include] ENDIF
IF [Product]='Grape' THEN 1
ELSEIF [Row-1:Product]='Banana' ...
[include] = 1
Simple
=
include
True
fixed
2019-09-09 14:45:02
0
2019-09-09 14:45:02
2019-09-09 14:45:02
1
[include] = 1
Horizontal
XLOOKUP