We all know, how to create a data form using rows, columns, page and POV. In this I want to explain how to add Formula rows/columns in Hyperion Web form. Here in this blog I have used application called VIZAGPLN. All the screenshots show this application only. Step-1: Go to Planning Application > Navigate > Applications > Planning > VIGAZPLN as shown below. Step-2: Go to Administration > Manage > Forms and Ad Hoc Grids to open the forms shown as below. Step-3: Select the form and click on edit, shown as below. Step-4: Go to Layout and click on edit select member selector icon to insert require Member/members in rows and columns as shown below. I will explore further how to add formula row/column with below three requirements for better understanding. Req1) Displaying Half year sales using Sum function: Sum function returns the sum of rows, columns or cell. Example:
Associate Trainee at Mouritech, Visakhapatnam