Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using a set analysis to calculate QTY.
COUNT({ $<flag={1,2}>}QTY)
The document has two selection fields one is date and other one is state.I don't want my set analysis to be affected by the 'state' selection.
Item | qty |
---|---|
Bags | 100 |
Bottles | 200 |
Please let me know how the set analysis needs to be modified that the qty values not gets changed by the State selection but can change by date selection.
Thanks....
Hi,
you just need to clear the state selection within your set expression:
=COUNT({ $<flag={1,2}, state= >}QTY)
Regards,
Stefan
Hi,
you just need to clear the state selection within your set expression:
=COUNT({ $<flag={1,2}, state= >}QTY)
Regards,
Stefan
Hi stefan,
Thank you so much for your help.It worked...