set analysis with empty value

[Anonymous]

Hi.

I'm trying to get the amount for a Family thats empty ([empty]). When i do like this;

sum({$<Family={}>} Amount)

The amount is 0

But when i select the empty value there is a value. How do i do this?

Thanks,

//A.

[kaushiknsolanki]

Hi,

    I am unable to understand your problem, Can you describe in detail. Or send the QVW file

Regards,

Kaushik Solanki

[Anonymous]

Sorry about that.

Ok. Let's say that we have family A, B, C, D but there's also an empty slot/value that is clickable

All familys has values (sum(Amount)).

In a table this will look like this:

A     300

B     330

C     430

D     200

       320

Notice here that the last value that's empty has a value. It's this value i want to get when writing the set analysis

sum({$<Family={}>} Amount)

[kaushiknsolanki · Accepted solution]

Hi,

    I am here by sending you the sample File.

    Hope this is what u r looking for.

Regards,

Kaushik Solanki

[Anonymous]

Thank you!

It worked great!

//A.

[#6]

Hi,

use this

=sum({<Family={''}>} amt)                                            

Regards,

Chandra