Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have an expression
=COUNT({<orders_invoice_date_year ={$(vyear1)}>}{<[Delivery Method] ={'GLD'}>}Distinct orders_order_no)
The second part of this seems to work where the delivery method = 'GLD' but the first part where i want to show only the orders where the variable is vyear1 is being ignored...
i am obviously missing something in this expression.
Can someone point me in the right direction with this?
Thanks!
=COUNT(
{<
orders_invoice_date_year ={'$(vyear1)'},
[Delivery Method] ={'GLD'}
>}Distinct orders_order_no)
=COUNT(
{<
orders_invoice_date_year ={'$(vyear1)'},
[Delivery Method] ={'GLD'}
>}Distinct orders_order_no)
Absolutely brilliant. Thanks very much Manish! I knew this would be simple for someone...