Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want eliminate NULL values ('-') from the from end report.
How to achieve this?
Thanks in advance.
Dept | Ename | EMPNo | SAL |
10 | Ename1 | EMPNo1 | 1,000.00 |
10 | Ename2 | EMPNo2 | 20,000.00 |
10 | Ename3 | EMPNo3 | 1,000.00 |
20 | Ename4 | EMPNo4 | 20,000.00 |
20 | Ename5 | EMPNo5 | 1,000.00 |
20 | Ename6 | EMPNo6 | 50,000.00 |
20 | Ename7 | EMPNo7 | 1,000.00 |
20 | Ename8 | EMPNo8 | 20,000.00 |
20 | Ename9 | EMPNo9 | 1,000.00 |
20 | Ename10 | EMPNo10 | 20,000.00 |
20 | Ename11 | EMPNo11 | 1,000.00 |
20 | Ename12 | EMPNo12 | 50,000.00 |
30 | Ename13 | EMPNo13 | 1,000.00 |
30 | Ename14 | EMPNo14 | 20,000.00 |
30 | Ename15 | EMPNo15 | 1,000.00 |
- | Ename16 | EMPNo16 | 20,000.00 |
- | Ename17 | EMPNo17 | 1,000.00 |
Hi,
Select Chart -> Straight Table -> Add dimension
Dept, Ename,EmpNo
Expression Sum(Sal)
In Dimesnion Tab-> Select Dept ->and check supress When Null
Regards
e.g.
load * resident where len(trim(Dept))>0;
Hi,
Select Chart -> Straight Table -> Add dimension
Dept, Ename,EmpNo
Expression Sum(Sal)
In Dimesnion Tab-> Select Dept ->and check supress When Null
Regards
Thank you dreamer4 and danieloberbillig
Do:
1 )In Dimensions tab, mark "suppress when value is null".
2)In presentation, mark "suppress missing" and "suppress missing values"
Same:
1> In Straight table: check "suppress when value is null" in Dimensions tab.
2> check "populate missing cells" And clear '-' from null symbol and missing symbol .