Hi Team,
I am having a table as follows
Model | Header1 | Header2 | Header3 |
---|
Mod1 | | | |
Mod2 | 0 | 1 | 1 |
Mod3 | | | |
Mod4 | 1 | 1 | 1 |
Mod5 | 1 | 0 | 1 |
Mod6 | 0 | 0 | 1 |
Mod7 | 1 | 1 | 1 |
Mod8 | 1 | 1 | 1 |
Mod9 | 0 | 0 | 1 |
Mod10 | 1 | 0 | 0 |
Mod11 | 0 | 0 | 0 |
Mod12 | | | |
Mod13 | 1 | 1 | 1 |
In above table there are model with null values in all other fileds.
In QV i need to represent as if(isnull(Header1)=0 or isnull(Header2)=0 or isnull(Header3)=0,Model) which is working fine by supressing the null values and showing 10 models of 13.
but my requirement is to present model as above expression and total for all 13 values
Please guide me