Forum Discussion
Solved
Complex Calculated Column Trouble
I have a calculated column with item sales as a percentage of total sales. It is just the total sales for each item divided by the total sales overall). I am trying to create a new column, based o...
Hi joshs444 ,
I tried to reproduced it.
You need to modify the [Sum Sales - Invoided Orders] as
Sum Sales - Invoided Orders = [Quantity]*[Unit Price][Percent Sales] now is good.
And it's the column to dispaly "TOP" and "BOTTOM".
Type = IF([Percent Sales]>0.2,"TOP","BOTTOM")Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi joshs444 ,
I tried to reproduced it.
You need to modify the [Sum Sales - Invoided Orders] as
Sum Sales - Invoided Orders = [Quantity]*[Unit Price]
[Percent Sales] now is good.
And it's the column to dispaly "TOP" and "BOTTOM".
Type = IF([Percent Sales]>0.2,"TOP","BOTTOM")
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.