You are working with a set of store revenues. All stores have positive revenue values. Which formula should you use to display the variance value of the Revenue measure in your document when data tracking is active?
Please choose the correct answer.
Response:

• A.=[Revenue]/RefValue([Revenue])
• B.=[Revenue]/HistValue([Revenue])
• C.=[Revenue]/PreValue([Revenue])
• D.=[Revenue]/BaseValue([Revenue])

Comment: *

Name: *

Email: *

Verification: *

Discuss the instructions appropriate for how you want the data in a table and manipulate the data within the table There are 2 correct answers to this question Response:

• A.In the target document, right-click the section cell and, from the contextual menu, click Copy and paste
• B.Drag and drop the table from Web Intelligence to the target application
• C.In the target application, right-click the area where you want the table to appear and, from the contextual menu, select Paste
• D.Right-click the table and, from the contextual menu, select Copy

Comment: *

Name: *

Email: *

Verification: *

Elucidate the advantages of saving formulas as variables?
Please choose the correct answer.
Response:

• A.Use variables in any report within the document
• B.You can reuse the formula without having to enter it each time
• C.Use as options available in the Format and Report Element toolboxes
• D.Create the formulas and feed it with all its dimensions

Comment: *

Name: *

Email: *

Verification: *

A variable in your report contains the statement:
=If[State] = "California" Then [Sales revenue] * 1.05 Else If[State] = "Colorado" Then [Sales revenue] *
1.1 Else If[State] InList ("DC";"Texas ") Then [Sales revenue] * 1.15 Else If[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue] Sales revenue for Florida is $1,879,159. Which rate is applied to the Florida revenue by the formula?
Please choose the correct answer.
Response:

• A.1.05
• B.1.18
• C.1.00
• D.1.10
• E.1.15

Comment: *

Name: *

Email: *

Verification: *

Which operator allows you to enter more than one operand value?

• A.In list
• B.Equal to
• C.Except
• D.Less than

Comment: *

Name: *

Email: *

Verification: *