Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
First time in the community and trying to setup a set analysis with multiple variable, but not having much luck. Wonder if someone can provide some help.
I am trying to sum Quantity based on Record type "Sales" but would want the analysis to exclude selection of Customer.
Below is what i have, but it doesn't seem to work as it is ignoring the "customer" exclusion.
=sum({<Customer=>}{$<RecordType={'Sales'}>}Quantity)
Please let me know if anyone has some suggestion.
Thanks,
Thomas
Try:
sum({<Customer=,RecordType={'Sales'}>}Quantity)
Thank you very much. It works!!!!!