2 Replies Latest reply: May 1, 2018 1:00 PM by Akshaya Aditya

# Formula Help

Hi,

Can anyone please advise what the issue is here with my formula syntax please as I can't get it to work.

sum(if(match([Personal],'Ian','Tom'),[Personal]),({<DATE_START = {">=\$(=yearstart(max(DATE_START)))<=\$(=today())"},year=,month=,[CITY] = {'NY'}>} Total_Value)

• ###### Re: Formula Help

Try this

Sum({<[Personal] = {'Ian','Tom'}, DATE_START = {">=\$(=YearStart(Max(DATE_START)))<=\$(=Today())"}, year, month,[CITY] = {'NY'}>} Total_Value)

• ###### Re: Formula Help

Hi Thomas,

You are using IF to find whether Personal is Ian and Tom but you are not using that within the expression. Below can be the correct expression

1 . sum({<DATE_START = {">=\$(=yearstart(max(DATE_START)))<=\$(=today())"},year=,month=,[CITY] = {'NY'},Personal = {'Ian','Tom'}>}Total_Value)

2. if(match([Personal],'Ian','Tom'),sum({<DATE_START = {">=\$(=yearstart(max(DATE_START)))<=\$(=today())"},year=,month=,[CITY] = {'NY'},Personal = {'Ian','Tom'}>}Total_Value))