2 Replies Latest reply: Mar 13, 2018 10:36 AM by Digvijay Singh

Formula Syntax

Antonio Forino Mar 13, 2018 10:31 AM

=Sum({<Month_Surgery={$(=concat(chr(39) & Month & chr(39),',') )},Year_Surgery={$(=concat(chr(39) & Year & chr(39),',') )},Day=,Year=,Month=,Quarter=>}WI_EUR)/1000

Hi Guys,

i have the formula above as you can se the Month_Surgery and the Year_Surgery is defined based on the Month and Year selection.

There's a way to add also the Day_Surgery on this formula? Means that based on the Day selection , the Day_Surgery is selected?

Thank you

Re: Formula Syntax

Sunny Talwar Mar 13, 2018 10:34 AM (in response to Antonio Forino)

May be try this

=Sum({<Month_Surgery = p(Month), Year_Surgery = p(Year), Day_Surgery = p(Day), Day, Year, Month, Quarter>}WI_EUR)/1000
Like Show 1 Like (1)

Actions
Re: Formula Syntax

Digvijay Singh Mar 13, 2018 10:36 AM (in response to Antonio Forino)

Do you have Day_Surgery field? if Yes, what problem you are facing if you are adding it the way you have added Month and Year? More info will help to understand the real issue.
Like Show 1 Like (1)

Actions

Go to original post