Structure Formula is incorrect

[Sanjivani Wayal]

Hi, 

I have used {field:Current Estimate}-{field:PresaleEstimate} to get the difference between 2 columns and Current Estimate is something which i created using formula its giving me error what should be used to get difference in such columns PresaleEstimate is a custom filed defined in JIRA so that is ok how can i define Current Estimate to get results

[David Niro · Accepted solution]

Hello @Sanjivani Wayal ,

At the moment, only Jira fields are available for use as variables in formulas (more here).

From your description, it sounds like Current Estimate is another formula column. 

The workaround here will be to use a local variable to define your Current Estimate value in the new formula.  It would look like this:

with _currentEstimate = your_formula_here :

_currentEstimate - presaleEstimate

Please let me know if this helps.

Best,
David

[Sanjivani Wayal]

_currentEstimate = your_formula_here : here there is no formula its a condition as below :-

IF originalestimate :
(originalestimate)
Else :
(presaleestimate)

How can i get this condition in variable and then use that variable in another formula

[David Niro]

Hello @Sanjivani Wayal ,

IF is a conditional statement that can be used in formulas.

The solution is the same. You just replace your_formula_here with the one you want to use, in this case an IF conditional statement.

with _currentEstimate = 
    IF originalestimate :
        (originalestimate)
    Else :
        (presaleestimate) 
:

_currentEstimate - presaleEstimate

There is more on the language used to create formulas in Structure here.  Please let me know if this helps.  

Best,
David

[Sanjivani Wayal]

It worked Thanks a lot