cognos报表数据项表达式函数的应用

2.1 aggregate..............................................................................................6

2.2 average.................................................................................................6

2.3 count.....................................................................................................6

2.4 maximum..............................................................................................7

2.5 median..................................................................................................7

2.6 minimum...............................................................................................7

2.7 moving-average....................................................................................7

2.14 running-average................................................................................11

2.15 running-count....................................................................................12

2.16 running-difference.............................................................................12

2.17 running-maximum.............................................................................13

2.18 running-minimum..............................................................................13

2.19 running-total......................................................................................14

2.20 standard-deviation............................................................................15

2.21 standard-deviation-pop.....................................................................15

2.22 total...................................................................................................15

2.23 variance............................................................................................15

3.5 _day_of_week....................................................................................18

3.6 _day_of_year......................................................................................18

3.7 _days_between..................................................................................19

3.8 _days_to_end_of_month....................................................................19

3.9 _first_of_month...................................................................................19

3.10 _last_of_month.................................................................................19

3.11 _make_timestamp............................................................................20

3.12 _months_between............................................................................20

3.13 _week_of_year.................................................................................20

3.14 _years_between...............................................................................21

4.2 _remainderSet....................................................................................22

5.1 add_months........................................................................................23

5.2 ascii.....................................................................................................23

5.3 char_length.........................................................................................23

5.4 chr.......................................................................................................23

5.11 instrb.................................................................................................25

5.12 least..................................................................................................26

5.13 length................................................................................................26

5.14 lengthb..............................................................................................26

5.15 lpad...................................................................................................26

5.16 ltrim...................................................................................................27

5.17 months_between..............................................................................27

5.18 new_time..........................................................................................27

5.19 next_day...........................................................................................28

5.20 nls_initcap.........................................................................................28

5.28 sign...................................................................................................30

5.29 soundex............................................................................................30

5.30 substr................................................................................................30

5.31 substrb..............................................................................................31

5.32 to_char..............................................................................................31

5.33 to_date..............................................................................................31

5.34 to_number........................................................................................32

5.35 translate............................................................................................32

5.36 trunc..................................................................................................32

5.37 trunc..................................................................................................32

5.39 {sysdate}...........................................................................................33

5.40 {user}................................................................................................33

6.1 cast_varchar.......................................................................................34

6.2 cast_timestamp..................................................................................34

7.1 Log......................................................................................................35

8.6 cosh....................................................................................................37

8.7 sin.......................................................................................................37

8.8 sinh.....................................................................................................37

8.9 tan.......................................................................................................38

8.10 tanh...................................................................................................38

9.1 _format................................................................................................39

9.2 _round.................................................................................................39

9.3 abs......................................................................................................39

9.11 exp....................................................................................................41

9.12 extract...............................................................................................41

9.13 floor...................................................................................................42

9.14 ln.......................................................................................................42

9.15 localtime...........................................................................................42

9.16 localtimestamp..................................................................................42

9.17 lower.................................................................................................43

9.18 mod...................................................................................................43

9.19 octet_length......................................................................................43

9.20 position.............................................................................................43

9.22 sqrt....................................................................................................44

9.23 substring...........................................................................................44

9.25 upper.................................................................................................45