hello how i can add shipping fees virtual column

hello i want add shipping fees virtual column for the orders so how its work and i need equations ! 

 this order details

 

order deteiles tableorder deteiles table

 orders tableorders tableorders tableorders table

 

Solved Solved
0 6 114
1 ACCEPTED SOLUTION

Well, if it's going to be a percentage of order total for example, it could be, in a virtual column:

0.03*[Total Cost]

View solution in original post

6 REPLIES 6

Aurelien
Google Developer Expert
Google Developer Expert

Hi @Hassan_Tanna 

 

Can you be more specific about how your shipping fees are calculated ? There is no shipping on any of the screenshot you provided.

By the way, I suggest a slight improvement on one of your expressions:

"Total Cost", or "Order Total" on the Orders Table (it's the same ?):

SUM([Related OrderDetails][Total])

yeah i dont have shipping fees  column so i thought i can add virtual column or i can change order total to shipping fees but whats will be the calculate !

Well, if it's going to be a percentage of order total for example, it could be, in a virtual column:

0.03*[Total Cost]

ok i can add virtual column for shipping feed and in  app formula add expression or equation to calculate between  product price  + shipping fess = total cost !

its work with me thank you 

Aurelien
Google Developer Expert
Google Developer Expert

Yes, it's up to you

Top Labels in this Space