Strucutre for Jira Booked time Formula

Question

Hi Community, can someone help me here with the Formul for my Stucture

∑ Booked time

if neither of the two fields actual effort of in the new expired period correction value previous year(s) has a content, then summation as before, this is how we do it till now:

IF WorkLogged > 0 :
    CONCAT(ROUND(JIRA_DAYS(WorkLogged), 1);" PT")

if the field Actual Effort of the expired period has content, it WILL be displayed in the new period;

if the field correction value previous year(s) contains a value, then totals are formed as before minus the specified correction value previous year(s).

It looks like this

best regards

David Niro · Answer

Hello @Jurica Petricevic ,

Not sure if my understanding is correct here, but you could try:

IF Actual_Effort != undefined:
    Actual_Effort
ELSE IF Correction_Value_Previous_Years != undefined:
    CONCAT(ROUND(JIRA_DAYS(WorkLogged)-Correction_Value_Previous_Years, 1);" PT")
ELSE WorkLogged > 0 :
    CONCAT(ROUND(JIRA_DAYS(WorkLogged), 1);" PT")

The first IF checks if Actual_Effort field is populated.  If it is, it uses this value.  If it is not, it moves onto the ELSE IF statement.

The ELSE IF statement checks if the Correction_Value_Previous_Years field is populated.  If it is, it uses the base formula you provided and subtracts the Correction_Value_Previous_Years value from it.  If it does not, it moves onto ELSE

ELSE is you base calculation.

Please let me know if this helps, or if I have misunderstood anything.

Best,
David

Clark Everson · Answer

Hi @Jurica Petricevic

there are members of the structure app on here but I would as it’s been a few days recommend submitting a ticket to them as well just so this doesn’t get lost. In general for third party apps the most sure fire way to get support is to reach out to the vendor.

happy new year!

clark