Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have 2 problem
1. I want create a expression based on other expression, just for a shake suppose I have 2 expressions in a straight table
a. sum( field 1) --- Column Name ----- Column 1
b. sum( filed 2) * sum( field 3 ) --- Column Name ----- Column 2
now I want to use both expressions in a other expression
c sum ( ( [ Column 1] / [ Column 2 ]) ),
or
sum([Column 1]) but it is given error bad field name [ Column 1 ] and [ Column 2]
2. I want running Row Nos. in a straight table
thanks & regards
use
Column (1) / Column (2) inplace of
sum ( ( [ Column 1] / [ Column 2 ]) )Instead of using this expre..
sum ( ( [ Column 1] / [ Column 2 ]) ),
Use
= sum( field 1) /(sum( filed 2) * sum( field 3 ))
hi, Jagan
thanks for quick reply,
there is a huge formulation in the expression of [ Column 1 ] & [ Column 2 ] it is my requirement that new expression is based on other 2 expression, so I cant use field in my desired Expression
use
Column (1) / Column (2) inplace of
sum ( ( [ Column 1] / [ Column 2 ]) )hi, Sunil thanks It is working
Please tell me about my II problem too.
thanks & regards
In expression you can
write
=Rowno()
hope this helps
hi, Sunil
yes, It is given me the actual row nos. but I want running Row Nos ( counter ).
Suppose in straight table after filter 6 row is coming then i want row nos like 1,2,3,4,5,6
and after another filter there is only 3 row then result should 1,2,3
thanks & regards
sorry i cant understand
can come again with more clear requirement?
I just want to serials the rows in straight table if there is 6 row in straight table then I want to serials them 1,2,3,4,5,6, if there is 4 rows then I want to serials them 1,2,3,4 means I just want to add a SNO. column in straight table.
I my opinion there is no need of rowno() function because it will return the serial no of loading time, I want to set serial no on straight tables's appearing record.
thanks & regards