Part 4b - Quantity & Revenue Forms

Avatar
Kepion Support
  • Updated

Author: Ian Britz

Introduction

Let's create the last two Forms we'll need. The Quantity Form will be very similar to the first two Forms in the Model, but will also include an extra row and column to display aggregated totals for each product and month.

 

mceclip1.png

 

The Revenue & Cost Form will also look similar, but won't be inputable. Instead, we'll use the Product Cost and Product Revenue Filters to view how much revenue we're making from our product (quantity x price) and how much it costs us to produce each product (quantity x cost of goods).

 

mceclip0.png

 

 

Quantity Form

Step 1. Let's create the Quantity Form first. We can copy it from either our Price or Cost of Goods Form.

 

39-add_quantity_form.png

 

Step 2. Let's change the Metric Filter to Quantity.

 

40-quantity_filter.png

 

Step 3. However, in this Form we're also going to add totals to the rows and columns, so let's navigate to the ROW tab and double-click the All member from the Member List. The order of selected members to the right is important here. If we wanted to display the [All] totals on the top of the Form, we could use the arrow buttons up.png down.png to move it above the child members.

 

41-row_all_member.png

 

Step 4. Then do the same thing in the COLUMN tab.

 

42-column_all_member.png

 

Step 5. Save and view the Form and we can see that a new row and column has been added. Note that these cells are not-inputable, as they're aggregations of other Dimension Members. Style the Form to differentiate it from the previous two.

 

43-quantity_form.png

 

 

Revenue & Cost Form

Step 1. Now let's create the last Form we need in the Assumption Model. Let's copy it from our Quantity Form, as it will also contain totals on the row and column. Name it Revenue & Cost.

 

44-revenue_and_cost.png

 

Step 2. We can change the default Filter to either Product Revenue or Product Cost for now, however note that this isn't technically necessary, as we're going to set the default at a later time when we add the Form to our Dashboard.

 

45-rc_filter.png

 

Step 3. Style the Form as you see fit, and then save.

 

46-rc_style.png

 

 

Next Steps

Now that all the Forms in our Assumption Model are ready, let's create our last two Forms we need, Operating Expense and Net Income.

Was this article helpful?
0 out of 0 found this helpful
Return to top

Comments

0 comments

Please sign in to leave a comment.

Related articles