Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
The following expression works perfectly:
=count({<CustomerID={'4'}>}distinct Orders)
However if I insert a variable to replace the 4 as follows I get zero
=count({<CustomerID={'(v_Selected_CounterPart_ID)'}>}distinct Orders)
I have tested the value in the variable and it is 4 so this should work.
The expression editor says the syntax is correct.
The variable is declared as
=GetCurrentField(CounterPart)
Very strange....
Thanks
Try this:
=count({<CustomerID={"$(v_Selected_CounterPart_ID)"}>}distinct Orders)
Try this:
=count({<CustomerID={"$(v_Selected_CounterPart_ID)"}>}distinct Orders)