Hi blom,
really appreciate your immediate response,
here i tried as you suggested but it shows irrelevenat and very larger values in the output year columns
i did as,
here i forgot to tell you one thisn year attribute is a datamember (created & calculated in report) as
RemYear ==-->...
Hello All,
in my list report (in cognos 8.3)
i am having
remcount
AmountRemit
above both are measures
now i am having weighted average as (it is a insertable object)WeightAVG= total ([AmountRemit]*[remcount])/total([remcount])
i have year objects as 2008 and 2009 and 2010
in each year...
hello all,
i am having a small report (with crosstab in it)
Column Year
Rows Currency,Country,productgroups (here i am grouping by these columns for sub totals)
then factcells are a calculated weigted average ---> total (sales * noOfItems) / total(noOfItems)
so till here i am...
Hello All,
in my report i have a simple cross tab, it sinmply contains 1 Cross Tab Row (some date column) , 1 Cross Tab Column ( quarter name) , measure column is some amount.
now when i run report it has some 90 rows it is displaying in 3 pages,
now the question is how can i set my cross tab...
(i am using Cognos 8.3 Report Studio)
Hello All,
in my Report, i am having 6 pages in it (ex: London Report, US, World, CAN, IND,EUROPE) each report having 2 queries in it (one for chart, one for list)
output is fine, when we run the report and saved it, it will save 6 pages in single PDF...
thanks for all whom ever tried at least to help me
Dear All,
it may helpful to some others
running-total([Amount]) + [OldBal] - [Amount]
works fine
this idea given by Jurri (Master)
Regards
asin
Hello All,
kindly any ideas please
basically the problem is need to calculate running total for a column (initiat start is stored in another dataitem)
this initial data item contains only one value
Hello All,
can you please give me a help hand regarding to the below problem
presently i have a report with structure as below in report studio (8.3)
TransactionDate,Detail,City,Amount,OldBal
Nov 1, 2008,paybill for x-x-11-2003,win,-1200.73,710.00
Nov 3, 2008,Call Card,win,33.45,710.00
Nov...
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.