Forum Stats

  • 3,853,765 Users
  • 2,264,266 Discussions
  • 7,905,444 Comments

Discussions

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

pawanis
pawanis Member 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.