Skip to Content
avatar image
Former Member

FMS QUERY FOR MARGIN

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    Hell@w Krishna:

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

    The datatype values are:

    0 (alfanumeric)

    DATE

    MONEY

    NUMBER

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 07, 2017 at 10:13 AM

    Hi

    check this thread.

    Kind regards

    Agustín Marcos Cividanes

    Add comment
    10|10000 characters needed characters exceeded