Skip to Content
0
Former Member
Sep 19, 2008 at 12:12 PM

calculate with DocTotal / $[$22.0.0]

45 Views

Hi,

we want automatically to calculate the freight costs. therefor i wrote this statement :

 SELECT ($[$22.0.0]*0.035) 

But if i start the select i got a SQL failure. It is not possible to calculate with this cell ?

It must be the displayed cell not the DocTotal from ordr, cause the calculation should be executed before

saving the order.

regards