Skip to Content
0

FMS QUERY FOR MARGIN

Nov 07, 2016 at 06:41 AM

60

avatar image
Former Member

HELLO EXPERTS AS PER MY CLIENT REQUIREMENT THE FMS QUERY WAS WAS DEVELOPED TO SHOW THE MARGIN IN ROW LEVEL BEFORE ADDING THE DOCUMENT select (($[pdn1.u_mrp]-$[pdn1.priceafvat])/$[pdn1.u_mrp])*100

while executing the query the following error is appearing in the screen

1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '-'. 2). [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement 'Blanket Agreement' (OOAT) (s) could not be prepared.

PLEASE PROVIDE THE SOLUTION FOR QUERY

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Sep 07, 2017 at 01:38 AM
0

Hell@w Krishna:

The sintax for detail field is: $[$Item.Column.Datatype]

The datatype values are:

0 (alfanumeric)

DATE

MONEY

NUMBER

Regards

Share
10 |10000 characters needed characters left characters exceeded
Agustin Marcos Cividanes Sep 07, 2017 at 10:13 AM
0

Hi

check this thread.

Kind regards

Agustín Marcos Cividanes

Share
10 |10000 characters needed characters left characters exceeded