How do you use SUM function in Reportnet?

Question Posted / hypercube solutions

3 Answers
9870 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do you use SUM function in Reportnet?..

Answer / lalitha

We have total() function in Expression Definition.
We can right click on the column and in functions block we
have total() function

Is This Answer Correct ?

4 Yes

0 No

How do you use SUM function in Reportnet?..

Answer / ambareesh.ko

in expression we can use this functions
ans by ambareesh.ko@gmail.com

Is This Answer Correct ?

1 Yes

0 No

How do you use SUM function in Reportnet?..

Answer / samba

tool box u have query calculation that u drg and drop to
the report page, query exprestion it will be open
automatically which one u want to do sum,for
ex:Qty*unitprice

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Cognos Interview Questions

what is tabular set? how can you break the report?

1 Answers Syntel,

11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance

1 Answers

15. If I select the current month and year how can we display previous 11 months data?

2 Answers TCS,

how to change the colour of the bar in charts...?

3 Answers IBM,

How do you call a store procedure within a transformation?

0 Answers

in which scenario we go for views in cognos or oracle?

1 Answers

What is dtm?

0 Answers

How to select multiple values from type-in prompt?