cancel
Showing results for 
Search instead for 
Did you mean: 

Total LC Formatted Search

Former Member
0 Kudos

Dear all,

I wanted to write a formatted search which will change my Total Lc to as Unitprice * Factor1, where factor1 is my quantity. I have written the below formatted search but it seems not to work the way i want it to work

SELECT $[$38.14.number] *t0.Factor1 From DLN1 t0

please someone to assist me on this.

Regards,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Antony,

i do not know what table DLN1 is, but re u sure that u do not need a where clause ?

You try to select every T0.Factor from DLN1. I think there are a lot values in Factor.

Also you need brackets afaik :


SELECT ($[$38.14.number]*t0.Factor1) From DLN1 t0

If you need the where your query should look like :


SELECT ($[$38.14.number]*t0.Factor1) From DLN1 t0 where t0.XXXX = $[$XXXX]

Regards

Former Member
0 Kudos

dear steffen,

i dont have a where clause dln1 is the delivery row table.. When i run the formatted search it returns more than 1 row.

Regards

former_member204969
Active Contributor
0 Kudos

Try to use this:

Select $[$38.14.number]*$[DLN1.Factor1.Number]

Answers (0)