Hello:
I need to exclude certain rows from the sum of the rest of the rows. I'm guessing that I'm missing something simple, but maybe not. My original expression, which is including the rows I don't want, is:
Num(Sum({<[Approval Completed Quarter] = {"2018-Q2"}, CCB_PROD_KEY3 -= {"VSI-Power (AIX)"}, CHANGE_TYPE *= {"Install"}>} NET_ASSETS), '#,##0')
I need to exclude rows where the Service Ordered value is like '*DBaaS*'. The full Service Ordered values are 'Database as a Service (DBaaS)' and 'DBaaS ICP2', that I want to exclude. I've tried modifying my original expression above to the following, but those rows are still included in the Sum total:
Num(Sum({<[Approval Completed Quarter] = {"2018-Q2"}, [Service Ordered] -= {"*DBaaS*"}, CCB_PROD_KEY3 -= {"VSI-Power (AIX)"}, CHANGE_TYPE *= {"Install"}>} NET_ASSETS), '#,##0')
As always, any and all help and responses is appreciated. Thanks in advance.
Message was edited by: Perry Newman - Corrected column name.
