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
