expression

[adiarnon]

hi,

i have this expression-

num(sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>}&_Del_Measure1

in the field _Del_Measure1 i have the end of the expression

but when im using it i get - error in the expression

what can i do?

adi

[vinieme12]

num(sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>}_Del_Measure1))

You see the Red Opening brackets indicate that the function is yet to be closed.

[trdandamudi]

To get a better understanding can you please post a small sample...

[MindaugasBacius]

num(sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>}&))_Del_Measure1

If you use only sum you will get the sum of the values in the field:

sum(&_Del_Measure1)

If you use inside the sum statement <{ Field = {"Value"}}> you will get the sum of the values where Field = Value. It's Set analysis. Try to search information in the community. It's plenty of blog posts.)

[Anil_Babu_Samineni]

&_Del_Measure1  -- Is that is Dimension or you want to show That value in &

[adiarnon]

I WANT TO BE MORE CLEAR-

hi,

i have 3 expression -

1.sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>}QTY)

2.sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"},Delivered= >}SALES)

3.sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"},Delivered={'0'} >}SALES)

I HAVE A LIST BOX _Del_Measure1

_Del_Measure1

>}QTY)

,Delivered= >}SALES)

,Delivered={'0'} >}SALES)

IM CHOOSING ON OF THE VALUES IN THE LIST BOX

END I WANT TO SEE THE RESAULT OF THE EXPRESSION-

sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>}&_Del_Measure1

ITS NOT WORKING

HOW CAN I DO IT?

ADI

[Anil_Babu_Samineni]

sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>}QTY) as QTY

sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"},Delivered= >}SALES) as SALES

sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"},Delivered={'0'} >}SALES) as ZeroSales

And then Merge QTY & SALES & ZeroSales as _Del_Measure1 then use this Don't dimension. I suggest you don't use Calculated Dimensions

Please let me know, If i am wrong?

[antoniotiman]

Try

num(sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>}  $(=_Del_Measure1)

Regards,

Antonio

[jonathandienst]

To make sure the expression will work even if nothing is selected:

=sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>}$(=MaxString(_Del_Measure1))