Is a rolling budget field possible?

[Scott Federman]

my company wants to manage their orders in jira. They want to have the parent issue contain a total budget and all the child tickets contain their costs which subtract from the total budget in the epic. Is this even remotely possible?

[Johnson Wang]

Hi @Scott Federman,

You can do this using the Power Scripts add-on.

There is a video tutorial walking you through in detail here, and we've also posted a short, sample script you can copy and paste or forward to your engineer.

Hope this helps!

Johnson

[Scott Federman]

@Johnson Wang

That was very helpful! Can this be used on other issue types like story as opposed to sub-tasks?

Scott

[Johnson Wang]

@Scott Federmanglad to hear it was hopeful :)

Yes, you can definitely modify this script so that it can be used between other issue types aside from just sub-tasks.

Hand the short script over to any engineer and they'll be able to quickly make the changes to the customfield IDs and logic for you.

[Scott Federman]

Hey All, 

Still having some issues getting the rolling budget to work. Would anyone be able to possibly show my what script will work for this? Here is the set up. 

Issue Types: 

• Project Budget
• Order Request

Custom Fields

• Budget (Project Budget)
• Remaining Budget (Project Budget)
• Expense (Order Request)

Link Type: Relates To

Function: Budget-Expense = Remaining Budget

Scenario: A project budget is entered into the budget field in the project budget issue type. Expenses are entered into the Expense field in the Order request issue type and then linked to the project budget using the relates to link type. The Remaining budget field is calculated and returned based on the expense being subtracted from the budget.

[Johnson Wang]

@Scott Federmandid you try this using the Power Scripts add-on, and following the video we recorded?

It should have addressed this exact use case for you, but let me know where you're still having challenges.

[Scott Federman]

Hi Johnson, 

It addressed the issue whereas the child is a subtask.  I am not using subtask however. It is a custom issue type of order request which is linked by "is related to". This will allow the user to create orders from the create screen instead of going into the "parent" issue and creating a subtask type which will eliminate a step for the user. 

I unfortunately dont have anyone who can help me script this function so any direction you could provide would be massively helpful.

[Jonathan Muse {Appfire}]

@Scott Federman if you would like assistance writing this script I would be happy to help. Just let me know.

[Scott Federman]

Thank you Alexey

Thats great news! I unfortunately am not a programmer and totally illiterate when it comes to writing scripts. Could you give me an example to work from? It would be simple subtraction.

[Alexey Matveev]

Yes, it is possible if you have a plugin like Adaptivist Scriptrunner or similair. In Scriptrunner you could create a scripted field which would make the calculations.