7 Replies Latest reply: Aug 3, 2015 4:35 AM by Tresesco B

# Error message: Error in set modifier expression

Hello All,

I created an expression for a variable but unfortunately it is not working:

Interval(Sum({<Date={'>=\$(=Date(Max(Date)))<=\$(=Date(Max(Date)))'},{<NextState={'96'}>}DurationPre/Count({<Date={'>=\$(=Date(Max(Date)))<=\$(=Date(Max(Date)))'},{<NextState={'96'}>}DurationPre)),'hh:mm:ss')

Error message: Error in set modifier expression

Any idea why?

Thanks

• ###### Re: Error message: Error in set modifier expression

=Interval((Sum({<Date={">=\$(=Date(Max(Date)))<=\$(=Date(Max(Date)))"},{<NextState={'96'}>}DurationPre)/Count({<Date={'>=\$(=Date(Max(Date)))<=\$(=Date(Max(Date)))'},{<NextState={'96'}>}DurationPre)),'hh:mm:ss')

try this

You didn't closed the first set analysis expression

• ###### Re: Error message: Error in set modifier expression

No luck.same error message :-(

• ###### Re: Error message: Error in set modifier expression

will you able to post the sample app?

• ###### Re: Error message: Error in set modifier expression

=Interval((Sum({<Date={">=\$(=Date(Max(Date)))<=\$(=Date(Max(Date)))"},NextState={'96'}>}DurationPre)/Count({<Date={'>=\$(=Date(Max(Date)))<=\$(=Date(Max(Date)))'},NextState={'96'}>}DurationPre)),'hh:mm:ss')

• ###### Re: Error message: Error in set modifier expression

Hi,

Try

Interval(Sum({<Date={'>=\$(=Date(Max(Date)))<=\$(=Date(Max(Date)))'},NextState={'96'}>}DurationPre) / Count({<Date={'>=\$(=Date(Max(Date)))<=\$(=Date(Max(Date)))'},NextState={'96'}>}DurationPre)),'hh:mm:ss')

Regards

• ###### Re: Error message: Error in set modifier expression

Hi Max,

It works fine now :-)

Thanks,

Hasvine

• ###### Re: Error message: Error in set modifier expression

Couple of issues noticed highlighted in red.

Interval(Sum({<Date={'>=\$(=Date(Max(Date)))<=\$(=Date(Max(Date)))'},{<NextState={96}>}DurationPre)/Count({<Date={'>=\$(=Date(Max(Date)))<=\$(=Date(Max(Date)))'},{<NextState={'96'}>}DurationPre)),'hh:mm:ss')

A date can't be '>=' and '<=' of a date (you used max(date)), It should ideally be some earlier date for '>=' comparison. May be like: