expression inline

[adiarnon]

hi,

im tring to add an expression inline-

DEL_INLINE:
LOAD * INLINE
[_DEL_View,_DEL,_Del_Measure
Quantity,1,num(sum({<SO_DELIVERED_STATUS=,[DELIVERY STATUS]=,SO_TYPE-={'1SLS','SRV'}>}SO_QTY_DEL),'#,##0')
Sale (K$),2,num(sum({<SO_DELIVERED_STATUS=,[DELIVERY STATUS]={'Delivered but Late','Delivered on time'},SO_TYPE-={'1SLS','SRV'}>}SO_LINE_SALES_VALUE_USD)/1000,'#,##0')
STD (K$),3,num(sum({<SO_DELIVERED_STATUS=,[DELIVERY STATUS]={'Delivered but Late','Delivered on time'},SO_TYPE-={'1SLS','SRV'}>}SO_LINE_STD_VALUE_USD)/1000,'#,##0')
];

i have two problem:

1. in my expression i have , so its taking the expression until the ,

2. i have in my set analysis field with space so i added [ ] and  its taking the expression until the ]

what can i do?

adi

[Frank_Hartmann]

try to set the expression in between quotation marks.

hope this helps

[gautik92]

I dont think you can use set analysis in scripting

[adiarnon]

tnx,

its resolve the , problem

but not the []

[sunny_talwar]

Try this may be:

DEL_INLINE:

LOAD * INLINE "

_DEL_View|_DEL|_Del_Measure

Quantity|1|num(sum({<SO_DELIVERED_STATUS=,[DELIVERY STATUS]=,SO_TYPE-={'1SLS','SRV'}>}SO_QTY_DEL),'#,##0')

Sale (K$)|2|num(sum({<SO_DELIVERED_STATUS=,[DELIVERY STATUS]={'Delivered but Late','Delivered on time'},SO_TYPE-={'1SLS','SRV'}>}SO_LINE_SALES_VALUE_USD)/1000,'#,##0')

STD (K$)|3|num(sum({<SO_DELIVERED_STATUS=,[DELIVERY STATUS]={'Delivered but Late','Delivered on time'},SO_TYPE-={'1SLS','SRV'}>}SO_LINE_STD_VALUE_USD)/1000,'#,##0')

" (delimiter is |);