Formula Sum gives unexpected behavior

[alwinsch]

Hi all,

I have the following formula in a chart.

sum (if(Load_month= 2,({<[Status AO] ={'In Behandeling'} + {'Gerealiseerd'}>}PrAO)))

But it gives some strange values, or better it gives me an error.

Please any help.

I want to show the sum of PrAO for one particular Load_month

and the Status should be one of the following: 'In Behandeling' + 'Gerealiseerd'

can anybody rewrite the formula?

Thanks,

Kind regards.

Alwin

[alwinsch · Accepted solution]

Nevermind... solved the problem myself.

sum

({<[Status AO] ={'In Behandeling'} + {'Gerealiseerd'}>}if(Load_month=2, PrAuto,0))

Thanks.

A.

[Nicole-Smith]

Try sum ({<Load_month = {2}, [Status AO] ={'In Behandeling'} + {'Gerealiseerd'}>}PrAO)