SUMIF issue

[cmutombo]

Hi Community

I found the good format, but syntaxes issue still continue :

1. =Sum({$<date( date#(DATE_,'M/D/YYYY h:mm:ss TT','M/DD/YYYY'))= {"$(=Date(Today()-1))"},SERVICE={'VOICE'}>}REVENUE)

or 

2. =Sum({$<[DATE_]= {"$(=date( date#(date(Today()-1), 'M/DD/YYYY') , 'M/D/YYYY h:mm:ss TT')"},SERVICE={'VOICE'}>}REVENUE)

Both of two are failed. May be for syntaxes (special characters)

Please Help

[rubenmarin]

Hi @cmutombo, the first one doesn't has a correct synta, in set analysis yo have to use a field name in the left side of the '='.

The 2nd can work if DATE_ is the name of a real field loaded in data model. maybe you need to use Timestamp() and timestamp#(), or remove the time part of the date function.

Also check which avlue returns =date( date#(date(Today()-1), 'M/DD/YYYY') , 'M/D/YYYY h:mm:ss TT') (or using timestamp) and confirm that there is a value in DATE_ field that matchs that value.

[cmutombo]

Hi rubenmarin

When i use the second, Message is "Error in set Modify ad hoc element in list..."

[cmutombo]

Hi rubenmarin

This the correct way

MANY THAAAAAAAANKS !!!!! 

=Sum({$<[DATE_]={"$(=timestamp(date(today()-1)))"},SERVICE={'VOICE'}>}REVENUE)