exclude string set and date today set analysis

[joeybird]

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

dataload

'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

please help

[sunny_talwar · Accepted solution]

Your double quote seems to be out of order:

Try this:

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

[Mark_Little]

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

[joeybird]

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

[sunny_talwar]

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

[joeybird]

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

[sunny_talwar]

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