If does not work

Tue, 22 Dec 2015 15:44:21 GMT

Hello, I have a chart in expression I put the following code:

if (

IsNull (Customer)

(((sum ({<Service = {'Type 1'}>} COST) / sum ({<Service = {'Type 1'}>} [Qty Equiv])) +

(sum ({<Service = {'Type 2'}>} COST) / sum ({<Service = {'Type 2'}>} [Qty Equiv])) +

)

- 10903) / 10903,

(((sum ({<Service = {'Type 1'}>} COST) / sum ({<Service = {'Type 1'}>} [Qty Equiv])) +

(sum ({<Service = {'Type 2'}>} COST) / sum ({<Service = {'Type 2'}>} [Qty Equiv])) +

)

- Sum (Proposal)) / sum (Proposal)

)

Customer is selected by a LIST object

If the client is empty it should return the value of the first expression, so far so good.

After I select a customer theoretically he should execute the second expression, data changes, but does not return the correct value.

They could help me with this error? thank you

Re: If does not work

Gysbert_Wassenaar — Wed, 23 Dec 2015 19:25:21 GMT

I'm pretty sure the expression you posted does not work at all. It's syntax is not correct.

This is not a condition that can be evaluated:

IsNull (Customer)(((sum ({<Service = {'Type 1'}>} COST) / sum ({<Service = {'Type 1'}>} [Qty Equiv])) +

(sum ({<Service = {'Type 2'}>} COST) / sum ({<Service = {'Type 2'}>} [Qty Equiv])) + )- 10903) / 10903