8 Replies Latest reply: Aug 13, 2015 6:19 AM by Sunny Talwar

# Formula error

Hello All,

I am trying to calculate all the calls of all my campaigns in an sql table for the day except for this campaign E4D46547D63403B4.

This is my actual formula but unfortunately it is not working:

=Count({<Date={'>=\$(=Date(Max(Date)))<=\$(=Date(Max(Date)))'}, CampaignId={'<>E4D46547D63403B4'}Indice)

Any idea?

Thanks,

Hasvine

• ###### Re: Formula error

Try this:

=Count({<Date={'>=\$(=Date(Max(Date)))<=\$(=Date(Max(Date)))'}, CampaignId -={'E4D46547D63403B4'}Indice)

=Count({<Date={'>=\$(=Date(Max(Date)))<=\$(=Date(Max(Date)))'}, CampaignId -={'E4D46547D63403B4'}>}Indice)

• ###### Re: Formula error

=Count({<

CampaignId-={'E4D46547D63403B4'}

>}

Indice)

If you want records for date greater than equal to max date and less than equal to max date, means all date.. No need of Date filter/selection.

• ###### Re: Formula error

Hi Manish,

The calculation works but i need the calculation for today's date only but it is giving me for all the data in the table.

KR,

Hasvine

• ###### Re: Formula error

Try this:

=Count({<Date={"\$(=Date(Max(Date)))"}, CampaignId -={'E4D46547D63403B4'}>} Indice)

• ###### Re: Formula error

all campaigns of the selection except E4....

=Count({<CampaignId-={'E4D46547D63403B4'} Indice)

all campaigns except E4....

=Count({<CampaignId=-{'E4D46547D63403B4'} Indice)

• ###### Re: Formula error

Just a minor change here: I overlooked it also the first time

all campaigns of the selection except E4....

=Count({<CampaignId-={'E4D46547D63403B4'}>} Indice)

all campaigns except E4....

=Count({<CampaignId=-{'E4D46547D63403B4'}>} Indice)

• ###### Re: Formula error

Count({<Date={"\$(=Max(Date))"}, CampaignId-={'E4D46547D63403B4'}Indice)