Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirement wherein I need to display few division sales from a set of division names.
As per the requirement, it should consider those division names which has the string 'SAP' and exclude one among that.
I tried as below,
=count({$<{"*SAP*"}-{'SAP Service'}>}Sales)
Can anyone please let me know if am on the right track. If not,please help me to achieve this requirement.
Thanks & Regards,
Smitha
Right track with a minor correction needed. May be like this?
=count({$<YourField = {"*SAP*"}-{'SAP Service'}>}Sales)
Right track with a minor correction needed. May be like this?
=count({$<YourField = {"*SAP*"}-{'SAP Service'}>}Sales)
Count({$<[Division Name] = {"*SAP*"}-{'SAP Service'}>}Sales)
Use SUM instead of Count if you want to calculate Total Sales.
Hi Smitha,
Try this
=count({$<YourField={"*SAP*"},YourField-={'SAP Service'}>}Sales)
hi,
Thanks for the solution.
Regards,S
Smitha
Thanks for the solution.
Thanks and Regards,
Smitha