Forum Discussion
Formula
- I want to fetch data to display at the template if division is A is selected, all the initiative under division A listed under dropdown to be selected
- I want to fetch data to display if Project A is selected, the template shows the prioritization and displays whether the budget type is Capex or Opex.
- The budget approve amount, will display amount 315,000 if project A budget type is Capex
Template
| No | Div | Initiative | Prioritization | Budget Type | Budget Approve Amount |
Table data
| Division | Initiative | Prioritization | Capex | Opex |
| a | Project A | P2 | 315,000.00 | |
| b | Project B | P1 | 2,400,000.00 | 860,000.00 |
| a | Project C | P3 | 860,000.00 | |
| d | Project D | P4 | 5,000,000.00 | |
| c | Project E | P2 | 5,000,000.00 | |
| a | Project F | P3 | 9,140,000.00 | |
| d | Project G | P4 | 5,000,001.00 |
4 Replies
- anyone can help?
All participants here are users like you who voluntarily spend some of their free time to help others. So you cannot expect an immediate reply.
Where do you want to select division A? And could you provide an example of what the output should look like?
- The output:
Division: a
Initiative: Project A
Prioritization: P2
Budget Type: Capex
Budget Approve Amount: 315,000.00
Division: a
Initiative: Project C
Prioritization: P3
Budget Type: Opex
Budget Approve Amount: 860,000.00
