Expression

[#1]

=sum({$<[PCI_Op_Name]={">=$(v_value)"}>}Direct_Cost) expresssion is ok butt on chart no value is displayed

v_value=10000

kindly check the expression

[manideep78]

Try like this:

Sum({<[PCI_Op_Name]={">=$(=v_value)"}>}Direct_Cost)

Hope this helps you.

Regards,

Manideep

[perumal_41]

Hi

i think  expression is worng. PCI_Op_Name field is varchar or numeric ,if varchar  [PCI_Op_Name]={">=$(v_value)"} expression won't work. only greater then or less then operator  used for numeric values comparsion.

please explain what your trying achive thorugh expression. we can able to help.

[#4]

Is the the PCI_Op_Name a string value?

So for example.

PCI_Op_Name =  Joe Bloggs

v_value = 10000

In your set analysis you are returning only  Joe Bloggs (PCI_Op_Name) > 10000 which would return Null.

What are you trying to achieve?

[#5]

PCI-OP_name is varchar

when i am using = sign it works butt when i used >= sign it does not work

[#6]

What values exist in your field?

[perumal_41 · Accepted solution]

Hi

only  can compare or filtered  numerric  through >= or <= symbol.

but varchar field can filtered through = symbol

[#8]

I am assuming that you have numeric and string values in the field.

So something like this should work

=Sum({<

  PCI_Op_Name = {"=IsNum(PCI_Op_Name) =-1"} - {"<10000"}

  >} Direct_Cost)