calculate with DocTotal / $[$22.0.0]

[Former Member]

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

[former_member204969 · Accepted solution]

Try this one:

Select  ($[$22.0.Number]*0.035)

[Former Member · Accepted solution]

it works fine...i did not know the argument "Number". It is for formating the query output ?

regards

edit: it works fine, if the formated search is in the same form. but i put it into the freight form. there i get a sql statement failure.

[former_member204969 · Accepted solution]

1. The Number keyword is for get the number portion of the field.

2. Sorry, but this reference is valid only inside the active form. When you open the freight form, then it will the active form.

(You can generate the value in a UFD and manually copy the value to the freight form.)

[Former Member · Accepted solution]

ok you are right, there were something like that in the b1 education lesson^^

thanks for reteaching and giving some ideas

[Former Member]

no text

[Former Member]

only solved if the query is in the same form