Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
HFR Reports - 11.1.2.3 - can we write a logic for 2 grids to show a difference

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
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
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)
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
Answers
-
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