| Author |
Message |
    
Fuhrer
Yavvanam Kaatesina Bewarse
Username: Fuhrer
Post Number: 1055
Registered: 07-2005
Posted From: 136.182.2.221
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, September 01, 2005 - 11:48 am: |    |
ha work ayyindi... kapotey konchem odd ga vundi same expression ni anni sarlu repeat chesthunte.. to_char ni to_number chesa.. thanks mama |
Fuhrer
Yavvanam Kaatesina Bewarse
Username: Fuhrer
Post Number: 1054
Registered: 07-2005
Posted From: 129.188.33.221
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, September 01, 2005 - 11:45 am: | |
try chesthuna wait a min mama |
Fuhrer
Yavvanam Kaatesina Bewarse
Username: Fuhrer
Post Number: 1053
Registered: 07-2005
Posted From: 129.188.33.221
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, September 01, 2005 - 11:45 am: | |
ha mama.. aitey nannu
Case
when(closed_on_dt is null) then to_char(sysdate - submitted_on_dt)
else
to_char(closed_on_dt - submitted_on_dt)
end repeat cheyyamantava in expression for 2nd cal |
Manishi
Mudiripoyina Bewarse
Username: Manishi
Post Number: 4276
Registered: 06-2004
Posted From: 129.9.163.233
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, September 01, 2005 - 11:42 am: | |
>>>when i refer to 1 cal field in expression to define 2 cal field, i got the error "1 cal field invalid column"
Fuhrer,
Why not code the entire calculation once again.
let us say cal1 = (col4 of table * col5 of table )
Now you want col2 to be based on cal1
so you can code ((col4 of table * col5 of table)/ 100 |
Fuhrer
Yavvanam Kaatesina Bewarse
Username: Fuhrer
Post Number: 1052
Registered: 07-2005
Posted From: 129.188.33.221
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, September 01, 2005 - 11:40 am: | |
ok mama... cheyyathi kada net lo dorakatla |
Fuhrer
Yavvanam Kaatesina Bewarse
Username: Fuhrer
Post Number: 1051
Registered: 07-2005
Posted From: 129.188.33.221
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, September 01, 2005 - 11:38 am: | |
mama
1 cal field
Case
when(closed_on_dt is null) then to_char(sysdate - submitted_on_dt)
else
to_char(closed_on_dt - submitted_on_dt)
end AS CT_SUBMIT_CLOSE
2nd cal field
Case
when(ct_submit_close <= 30) then '30 Days or Less'
when(ct_submit_close > 30 and ct_submit_close <= 60) then '31 to 60 Days'
when(ct_submit_close > 60 and ct_submit_close <= 90) then '61 to 90 Days'
when(ct_submit_close > 90 and ct_submit_close <=120) then '91 to 120 Days'
when(ct_submit_close > 120 and ct_submit_close <= 150) then '121 to 150 Days'
when(ct_submit_close > 150 and ct_submit_close <= 180) then '151 - 180 Days'
when(ct_submit_close > 180) then 'More than 181 Days'
end AS SUB_TO_CL_OR_SUB_TO_TDY_DT_RNG,
error: invalid column name ct_submit_close |
Hemanth
Celebrity Bewarse
Username: Hemanth
Post Number: 7295
Registered: 03-2004
Posted From: 63.110.106.226
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, September 01, 2005 - 11:38 am: | |
naaku antha chithram ledu mama, megamam ravalsinde.  |
Fuhrer
Yavvanam Kaatesina Bewarse
Username: Fuhrer
Post Number: 1050
Registered: 07-2005
Posted From: 136.182.2.221
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, September 01, 2005 - 11:33 am: | |
thanks mama
>>For example, to add a calculated column that displays the average of two existing columns (Column_1 and Column_2), you type ([Column_1] + [Column_2]) / 2 in the Formula box.
naa requirement simple ga
view lo 2 calculated columns include chayyali mama
1 cal field - based on columns of underlying table
2 cal field - based on 1 cal field
when i refer to 1 cal field in expression to define 2 cal field, i got the error "1 cal field invalid column" |
Hemanth
Celebrity Bewarse
Username: Hemanth
Post Number: 7293
Registered: 03-2004
Posted From: 63.110.106.226
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, September 01, 2005 - 11:26 am: | |
On the top link bar, click Documents and Lists.
On the Documents and Lists page, click the list, document library, or discussion board in which you want to add a column.
On the page that displays the list, document library, or discussion board, click Modify settings and columns.
In the Columns section, click Add a new column.
In the Name and Type section, in the Column name box, type a name for the column.
Select Calculated (calculation based on other columns).
In the Optional Settings for Column section, type a description for the column.
This step is optional.
In the Formula field, enter a formula to calculate the information in this column.
How?
Columns that are already part of the list or library appear in the Insert Column list. To include an existing column in the equation, click the item and then click Add to formula.
You can also type the names of columns manually by enclosing them in square brackets ([ ]). For example, to enter the Title column in the formula, you type [Title].
In your equation, you can use all of the standard math, comparison, and logical operators, such as +, -, /, *, %, ^, >, <, >=, <=, <>, &, OR, NOR, and XOR.
To insert text into an equation, place the text between quotation marks. Spaces not in quotation marks are ignored.
For example, to add a calculated column that displays the average of two existing columns (Column_1 and Column_2), you type ([Column_1] + [Column_2]) / 2 in the Formula box.
At the bottom of the page, click OK.
http://office.microsoft.com/en-us/assistance/HA011 611601033.aspx
Just check that, it may help u. |
Fuhrer
Yavvanam Kaatesina Bewarse
Username: Fuhrer
Post Number: 1049
Registered: 07-2005
Posted From: 129.188.33.221
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, September 01, 2005 - 11:22 am: | |
megamama vunnava |
Fuhrer
Yavvanam Kaatesina Bewarse
Username: Fuhrer
Post Number: 1048
Registered: 07-2005
Posted From: 129.188.33.221
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, September 01, 2005 - 11:20 am: | |
view lo calculated column vundi.. danni base chesukuni inko calculated column create cheyyatam ela... evaraina konchem cheppandi |
