R
Ramon Schouten
Guest
Hi all, I have run into a formula problem I can’t figure out on my own, so I am counting on you[
] I am trying to create a formula, which will calculate the total amount my project will cost. This total cost will exist of all the approved budgets. The total cost will exist of some already defined expression fields. These expression fields exist of the following formulas: - Project budget incl. Indexation incl. VAT (The initial budget of the project * indexation) *1,21 (VAT) - Exception budget incl. Indexation incl. VAT (The budget of changes or exceptions that occur on the project * indexation) * 1,21 (VAT) These exceptions have an approval chained to them. The approvals changes the workflow status, occurring to which approval has been done. My wish is to only use the exceptions which are ‘Approved’, so with the workflow status ‘Approved’ (this means they need to have been approved by the final approver) How can I make sure I get a total calculation of the project cost + the cost of all exceptions which have been approved (related to this specific project)? Thanks in advance and I look forward to hearing from you! Greetings, Ramon Schouten QAP P3 Solutions
Continue reading...
] I am trying to create a formula, which will calculate the total amount my project will cost. This total cost will exist of all the approved budgets. The total cost will exist of some already defined expression fields. These expression fields exist of the following formulas: - Project budget incl. Indexation incl. VAT (The initial budget of the project * indexation) *1,21 (VAT) - Exception budget incl. Indexation incl. VAT (The budget of changes or exceptions that occur on the project * indexation) * 1,21 (VAT) These exceptions have an approval chained to them. The approvals changes the workflow status, occurring to which approval has been done. My wish is to only use the exceptions which are ‘Approved’, so with the workflow status ‘Approved’ (this means they need to have been approved by the final approver) How can I make sure I get a total calculation of the project cost + the cost of all exceptions which have been approved (related to this specific project)? Thanks in advance and I look forward to hearing from you! Greetings, Ramon Schouten QAP P3 SolutionsContinue reading...