This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,924 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

HFR Reports - 11.1.2.3 - can we write a logic for 2 grids to show a difference

pawanis
pawanis Financial AnalystWashington,DCMember Posts: 92
edited Jun 14, 2017 1:16PM in Hyperion Query and Reporting

Hello everyone,

I am here with a new question for the day. Using HFR studio 11.1.2.3 v

I have  grid 1 and Grid 2 with below dimensions layout format

pastedImage_0.png

In Grid 1, I am calculating the report on Parent level only such that it displays data like below. Pls watch the RED color in POV

pastedImage_1.png

In Grid 2, I am calculating the report for a single member under a Parent account such that it displays data like below. Pls watch the RED color in POV (Custom 2)

pastedImage_4.png

Reason to do this is - In Grid 1, Parent level is pulling up expired funds (custom2) and I would like to calculate a variance between Grid 1 2016  data - Grid 22016 data.

Output in Grid 1 should be like 12,656 - 391 =12,265 .

I am not sure how to show the output difference in Grid1.

Appreciate all your inputs and thanks for your time

Tagged:
3194252

Answers

  • Komala-Oracle
    Komala-Oracle Member Posts: 2 Employee
    edited Jun 14, 2017 1:16PM

    Insert formula column in first grid and select entire column and use following formula : Grid1.[B]-Grid2.[B] then you will get the expected results.

    Ex : Grid1.[B] = 12656

          Grid2.[B] = 391

          Grid1.[B]-Grid2.[B] = 12,265

    3194252
This discussion has been closed.