the prob is i am trying to create a report which shows particular months salary by pay group along with year to date salary on same line. some times i have a group which is not paid for the month. some where i am going wrong with my report
is you prob solved. if not u can just use this simple formula instaed.
space(64-length({tab1.fld1}))&{tab1.fld1}
where tab1.fld1 is ur fieldname.
i use this for my sorting in reports which have alpha numeric values.
near the suppress section of the details or what ever place where u keep these values write a formula like this.
if ucase(left({invoicefld},1)) <> 'X' and
left({outvaluefld},1) <> '-' then true else false
here i am assuming out value field is a string. if its not then write as below
if...
for version 9 u can create fake page numbers. if u goto business obk=jects.com and type fake page number in search u will get the solution. they have it
try this
If (
Sum ({review_answer.score}, {review_answer.REVIEW_HEADERREF}) >= 21
and Sum ({review_answer.score}, {review_answer.REVIEW_HEADERREF}) <= 40
)then "C
insert a cross tab as follows
select dept for column
Employee name for row
salary and Rate for summary values and select summary type as mode. In the customize tab, from the summerized fields select horizontal
The Val (str) function reads a string containing Numbers (example: an address, phone number, or social security number) and converts them to a decimal value. Val stops reading the string when it finds the first character in the string that it finds that it can not recognize as a number or as a...
i tried the followingformula u gave
if {Sheet1$.Reference} startswith "s" then
tonumber(replace(mid({Sheet1$.Reference},3,len({Sheet1$.Reference})),"-",""))
else if {Sheet1$.Reference} startswith "r" then tonumber(replace(mid({Sheet1$.Reference},6,len({Sheet1$.Reference})),"-",""))
else 0
it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.