Formula error

[#1]

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

[sunny_talwar]

Try this:

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

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

[MK_QSL]

=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.

[maxgro]

all campaigns of the selection except E4....

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

all campaigns except E4....

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

[sasiparupudi1 · Accepted solution]

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

[sunny_talwar]

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)

[#7]

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

[maxgro]

thanks

[sunny_talwar]

Try this:

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