Using If Condition, the set analysis expression is not working

[#1]

Hi,

In the below expression is not working because of exclution of -=, could you please any one suggest where its wrong.

=If(Title='Nb_Invo',Count({$<[Year]={$(PY)}, [Status]-={'A'}>}DISTINCT [Invoice Number]),

If(Title='Nb_Ship',Count([TransNo))

Regards

Chriss

[Gysbert_Wassenaar]

Try adding a final ) at the end of your expression:

=If(Title='Nb_Invo',Count({$<[Year]={$(PY)}, [Status]-={'A'}>}DISTINCT [Invoice Number]),If(Title='Nb_Ship',Count([TransNo)))

The expression editor has a bug so -= will show a red underline. But the syntax is correct. If the expression doesn't calculate the correct result it's not because [Status]-={'A'} isn't the right syntax.

[MayilVahanan]

HI

If your  full expression is

=If(Title='Nb_Invo',Count({$<[Year]={$(PY)}, [Status]-={'A'}>}DISTINCT [Invoice Number]),

If(Title='Nb_Ship',Count([TransNo)) only means,

You didn't closed the if condition

=If(Title='Nb_Invo',Count({$<[Year]={$(PY)}, [Status]-={'A'}>}DISTINCT [Invoice Number]),

If(Title='Nb_Ship',Count([TransNo)))