Hello,
I am currently creating a report on Crystal 11 and I have created a bunch of an if then formulas. I ended up with 4 formulas:
Price 1, Price 2
Cost 1, Cost 2
What I did on Price 1 formula was (and this pretty much applies to the other formulas accordingly):
IF period = 1 THEN sales_price ELSE 0
The problem is, I need to group those formulas by price and cost. So that I will be able to sum up my total by sales or cost.
Price
Price 1 Price 2
100 200
0 50
Total 100 250
Cost
Cost 1 Cost 2
75 50
0 25
Total 75 75
Grand Total.....etc.
Any advice will be greatly appreciate it. Thx.
I am currently creating a report on Crystal 11 and I have created a bunch of an if then formulas. I ended up with 4 formulas:
Price 1, Price 2
Cost 1, Cost 2
What I did on Price 1 formula was (and this pretty much applies to the other formulas accordingly):
IF period = 1 THEN sales_price ELSE 0
The problem is, I need to group those formulas by price and cost. So that I will be able to sum up my total by sales or cost.
Price
Price 1 Price 2
100 200
0 50
Total 100 250
Cost
Cost 1 Cost 2
75 50
0 25
Total 75 75
Grand Total.....etc.
Any advice will be greatly appreciate it. Thx.