Can any one please do needful on Getting Exact Values of Total in Text box eliminating Nulls.
Hi friends,since last couple of days facing an Issue with handling of null and to eliminate the complete row where ever value is null in Dimension drop the complete row.My Question is simple and straight i have a measure with Target while showing in St Table for Individual dimension all values are matching and total i'm getting is Avg=23.26%,but expected 21.5% (to get these need to eliminate null value rows Excel 52 and 56 records has null value of Target)certain columns having null values.when ever it is null i need to eliminate complete row in calculations >?I have attached Excel source and made how i need to get the desired output.Please help on these resolved.
Re: Can any one please do needful on Getting Exact Values of Total in Text box eliminating Nulls.
It should be just as easy to do it on a script level.
F2 <> '' AND F1 <> '';
Excel doesn't have regular Null-values as such but they might be interpreted as such during the LOAD process in a load script. So I can't remember on the fly whether you will have to test for empty strings like I did above or if QlikView translates them into Null-values ....