Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello - I need help to calculate the True & False % & sale of each product.
Result %
Status | Sale |
FALSE | 42.55% |
TRUE | 57.45% |
Total | 100.00% |
Result Sale
Status | Sale |
FALSE | 205,900.00 |
TRUE | 278,000.00 |
Total | 483,900.00 |
Data Table 1
Product | Code | Status |
Apple | 1 | FALSE |
Mango | 2 | TRUE |
Banana | 3 | TRUE |
Juice | 4 | TRUE |
Grapes | 5 | FALSE |
Melon | 6 | FALSE |
Watermelon | 7 | TRUE |
Data Table 2
Code | Sale |
1 | 250 |
2 | 3500 |
3 | 4150 |
4 | 4800 |
5 | 5450 |
6 | 6100 |
7 | 6750 |
1 | 7400 |
2 | 8050 |
3 | 8700 |
4 | 9350 |
5 | 10000 |
6 | 10650 |
7 | 11300 |
1 | 11950 |
2 | 12600 |
3 | 13250 |
4 | 13900 |
5 | 14550 |
6 | 15200 |
7 | 15850 |
1 | 16500 |
2 | 17150 |
3 | 17800 |
4 | 18450 |
5 | 19100 |
6 | 19750 |
7 | 20400 |
1 | 21050 |
2 | 21700 |
3 | 22350 |
4 | 23000 |
5 | 23650 |
6 | 24300 |
7 | 24950 |
Solved! Go to Solution.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |