topic How to exclude in App Development

How to exclude

Spartan27215 — Mon, 31 Oct 2022 14:34:24 GMT

How do I go about doing this...

1. I have a Dollar amount as a measure

2. I have A certification as a dimension.

I want to compare the Dollars for having the certification vs not having the certification.

The easy part is Has the Certification...

<$<Certification={'Cert A'}>} DollarAmount

The question is how to do this to get the opposite? Note the below does not work

<$<Certification={'<>Cert A'}>} DollarAmount

BrunPierre — Mon, 31 Oct 2022 14:44:25 GMT

vinieme12 — Tue, 01 Nov 2022 03:05:20 GMT

As below

=sum({$-<Certification={'Cert A'}>} DollarAmount)

=sum({<Certification-={'Cert A'}>} DollarAmount)