Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Your double quote seems to be out of order:
Try this:
=Count({$<Department = {'Furniture'}, DateType = {'Daily'}, OrderDate = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>}Customer_No)
Your double quote seems to be out of order:
Try this:
=Count({$<Department = {'Furniture'}, DateType = {'Daily'}, OrderDate = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>}Customer_No)
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.
Mark
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
Never really understood the difference between Today() and Today(1) (and even seen Today(2)). But I am glad it finally worked.
I have guessed .... you think its something to do with time zones? as uk, this works as today (1)
Could be. May be hic can shed some light on this.