6 Replies Latest reply: Nov 18, 2015 2:27 PM by Sunny Talwar

# exclude string set  and date today set analysis

Hiya

I have a calculation - set analysis  as follows

count({\$< Department = {"Furniture"} >}Customer_No)

but my two tables have a string in my data load

e.g

'Daily' AS "DateType"  .......Table 1

'Weekly' AS "DateType"  .......Table 2

I need it only to count

count({\$< Department = {"Furniture"}, DateType="{Daily"} >}Customer_No)

but I still have to on the filter pane DateType select the  Daily, for the correct number to show

also I need to only include OrderDate Today(),  weirdly in kpi on date shows  1899

• ###### Re: exclude string set  and date today set analysis

Your double quote seems to be out of order:

Try this:

=Count({\$<Department = {'Furniture'}, DateType = {'Daily'}, OrderDate = {"\$(=Date(Today(), 'YourDateFieldFormat'))"}>}Customer_No)

• ###### Re: exclude string set  and date today set analysis

Hi,

Sunny's suggest should point you in the right directions. I might be mis-understanding, but are you using multiple calendars? This can cause issues if not set up correctly, The below document can help if that is the case.

Canonical Date

Mark

• ###### Re: exclude string set  and date today set analysis

this worked brill, but weird reason needed a today (1)

=Count({\$<Department = {'Furniture'}, DateType = {'Daily'}, OrderDate = {"\$(=Date(Today(1), 'YourDateFieldFormat'))"}>}Customer_No)

thanx team

Kind Regards

• ###### Re: exclude string set  and date today set analysis

Never really understood the difference between Today() and Today(1) (and even seen Today(2)). But I am glad it finally worked.

• ###### Re: exclude string set  and date today set analysis

I have guessed .... you think its something to do with time zones? as uk, this works as today (1)

• ###### Re: exclude string set  and date today set analysis

Could be. May be hic can shed some light on this.