Finance Service Desk, Finance formula

[Pii]

I'm using Jira Service Management, I'm looking for "Sum "formula in form create. How can i resolve it? 

[Dmitry]

You want field with Summ of some other fields on create form? With interactibe calculate?

May be plugin Jira workflow toolbox - with custom field "Calculated number field by JWT" with dynamically calculated in real time

[Sergio García-Consuegra _Decadis AG_]

Hi @Pii ,

Our plugin Jira Workflow Toolbox offers the calculated number custom fields, which allow you to calculate dynamically different values.

Could you please give more details about which functionality do you need to achieve? Do you want to calculate a specific value after a form has been created?

If you could give us an example indicating the expected behaviour, we could propose you a solution using our plugin.

Hope to hear from you soon!

Best regards,
Sergio

[Pii]

I have create Form directly with Request_Type on "Cash Advance", I'd like to calculate subtotal automatically.  Any recommend?

[Dmitry]

Only what has already been offered 

• plugin Jira workflow toolbox - with custom field "Calculated number field by JWT"

It's powerfill plugin with more others functions and automation rules

Native Jira can't it and i didn't see alternative JWT for it

[Sergio García-Consuegra _Decadis AG_]

Hi @Pii ,

We could give you a solution using our Cloud plugin Smart Fields for Jira, concretely using a Smart Number field.

In this case, we could calculate the total amount in KHR after the request has been created, not during the creation.This value would be stored in a custom field.

Would you be interested in this solution?

Best regards,
Sergio

[Pii]

I try to get it and not possible. 

[Sergio García-Consuegra _Decadis AG_]

Hi @Pii ,

Could you please try if you can do the following?

• Go to Settings > Issues > Fields > Custom fields.
• Try to create a Smart number field . Did it work?

Regarding the problem you had trying to access the app, that problem should be gone if you de-install and re-install the Smart Fields plugin.

Could you please confirm if after following those steps everything worked as expected? If it's the case, I could provide you the proposed solution for this issue.

Thank you!

Best regards,
Sergio

[Pii]

Hi @Sergio García-Consuegra _Decadis AG_ 

It's same result. 

I have create custom field and config loading.... after that show that status

:(

[Pii]

Hi @Sergio García-Consuegra _Decadis AG_ ,

Can you please share me coding for execute Total Amount after create issues? 

I'm none technical coding 

[Sergio García-Consuegra _Decadis AG_]

Hi @Pii ,

Does the problem still persist? Please, do the following steps in order to create and use a Smart Number field and let us know the result.

• Go to Settings > Issues > Fields > Custom fields.
• Create a Smart number field .
• After the field being created, click in the three dots and select "Context and default value"

• In the configuration menu, select "Edit custom field config"
• Use the following expression:

  %{sum([{issue.cfAAAAA},{issue.cfBBBBB},{issue.cfCCCCC},{issue.cfDDDDD},{issue.cfEEEEE}])}

Replace AAAAA, BBBBB, CCCCC, DDDDD, EEEEE for your linked "Amount HKR" field codes from your form, so the sum is made with those fields. If you need to know the custom field code, you can search a field after clicking on "Add field":

After finishing the expression, click on "Save" and go to any of your issues. Were the values summed correctly? Did you have any problem?

Please let us know and we will gladly help you!

Best regards,
Sergio

[Pii]

Hey @Sergio García-Consuegra _Decadis AG_ ,

Just confirm that only execute cannot show in Project Issues? 

[Sergio García-Consuegra _Decadis AG_]

Hi @Pii ,

• What do you mean exactly? Do you mean that the created custom field is not appearing in the issues from your project? Could you please give us more details on that?
• Did you associate the corresponding project/screens to this created Smart field fields?
• Did you save the configuration for your fild after writing the expression?

Please, give us a detailed answer about what is the current problem.

Thank you!

Best regards,
Sergio

[Pii]

Okay It's working now. you can close this request

[Sergio García-Consuegra _Decadis AG_]

Hi @Pi ,

I'm glad to hear the proposed solution worked for you!

If you have any other doubt related to Smart Fields, you can open a new request in our official support portal for our products. We will gladly help you with your requests! :)

Also, if you want to know more about Smart Fields for Jira and all the possibilities it offers, here you have a link to our official documentation.

If you are satisfied with our plugin, it would mean a lot to us if you could share your opinion in the Atlassian Marketplace.

Have a great weekend!

Best regards,
Sergio