Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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)))