Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I had a similar issue. So I have two columns, PART AND CUBES, with one to many relationship.(one PART can have many CUBES or a PART can have no CUBE).
Scenario: If I select 3 PARTS which have 2 CUBES, wherein 2 PARTS have 2 CUBES and 1 PART has no CUBE. I want a count of all the CUBES plus any PART which has no CUBES.
PART | CUBES |
SW1001 | 1415TV |
DC1003 | 1323GT |
BW1002 |
So the count should be 2+1=3.
How can I implement this?
Regards,
Abhishek
Count(CUBES) + Count({<PART={"=IsNull(CUBES)"}>}PART)
Count(CUBES) + Count({<PART={"=IsNull(CUBES)"}>}PART)