nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

I cannot get a simple substraction between Custom Fields value to work

Xavier Lecomte

Hello

I need a field to be populated with the number of month to go till the end of the year.

His number will be based on a custom Start Date. In a separate question Ludo has helps me parsing the Month number from a Custom Start Date Field.

Now I have this "Month Number" parsed I want to do :

"# Months to go" = "13" minus "Month Number"

I don't understand why the following syntax does not work :

when custom field "Probable Start Date" is set to a date, set custom field "PROB MONTH" to "{{%Probable Start Date}~MM}", and set custom field "YTG Impact" to "{{%FY+1}} - {{%Prob Month})"

All custom fields below are number (except date)

"YTD +1" being set to "13"

"Probable Start date" being set to "April, 15, 2020"

"Prob Month" is correctly evaluated as "4"

but "YTG Impact" is incorrectly set to "13" when I expect 13 - 4 = "9"

I have also tried :

set custom field "YTG Impact" to "13 - {{%Prob Month})"

same result the set always consider only the first term of the operation

Accepted answers

Ludo_gn7289

There is probably a syntax error.

Try this :

{{%FY}+1 - {%Prob Month}}

or {13 - {%Prob Month}}

or 13-({{%Prob Month}})

or ({{%FY}} - {{%Prob Month}})+1

Iain Dooley

@Xavier Lecomte this works for me:

when custom field "Start Date" is set to a date, set custom field "Prob Month" to "{{%Start Date}~MM}", and set custom field "YTG Impact" to "{{%FY+1}} - {{%Prob Month}}"

I think your only problem is that you have included a close parenthesis instead of a closing curly brace, that is this:

when custom field "Probable Start Date" is set to a date, set custom field "PROB MONTH" to "{{%Probable Start Date}~MM}", and set custom field "YTG Impact" to "{{%FY+1}} - {{%Prob Month})" <---- note the parenthesis here

should be this:

All comments

Ludo_gn7289

There is probably a syntax error.

Try this :

{{%FY}+1 - {%Prob Month}}

or {13 - {%Prob Month}}

or 13-({{%Prob Month}})

or ({{%FY}} - {{%Prob Month}})+1

Xavier Lecomte

Thank you for the attempt. Unfortunately none of the above gives the expected result. Have you ever seen the arithmetic on Number Custom Field Variables working?

Ludo_gn7289

Not tested. But visibly it is possible. See this :

https://help.trello.com/article/1161-custom-field-arithmetic

https://help.trello.com/article/1159-arithmetic-in-date-variables

@Xavier Lecomte

I just have tested this rules, and it works for me

when custom field "Date" is set, set custom field "n1" to "{{%Date}~MM}", and set custom field "n2" to "{{%n1}}+3"

when custom field "Date" is set, set custom field "n1" to "{{%Date}~MM}", and set custom field "n3" to "{{%n1}}+{{%n2}}+3"

Iain Dooley

@Xavier Lecomte this works for me:

when custom field "Start Date" is set to a date, set custom field "Prob Month" to "{{%Start Date}~MM}", and set custom field "YTG Impact" to "{{%FY+1}} - {{%Prob Month}}"

I think your only problem is that you have included a close parenthesis instead of a closing curly brace, that is this:

should be this:

Xavier Lecomte

Hey Ludo

Thank you

Below my syntax and that does not work :

when custom field "Probable Start Date" is set to a date, set custom field "PROB MONTH" to "{{%Probable Start Date}~MM}", and set custom field "YTG Impact" to "13-{{%Prob Month}}"

I think I will go to the support but wanted to thank you

Xavier Lecomte

Hey Iain

Thank you

Below my syntax and that does not work :

when custom field "Probable Start Date" is set to a date, set custom field "PROB MONTH" to "{{%Probable Start Date}~MM}", and set custom field "YTG Impact" to "13-{{%Prob Month}}"

I think I will go to the support but wanted to thank you

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

custom-field

trello

variable

butler

calculation