Skip to Content
avatar image
Former Member

Webi 14.2.3 Count object between 2 Dates

Hello Team,

Since this morning I try to find a solution to count object between two dates.

But I can't found a solution.

To explain you I created an Excel file with my data and a result tab. But I can't attach an Excel File.

Can you help me please ?

data-example.txt

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 05, 2017 at 03:09 PM

    Hi ,

    Is start and End dates are separate columns in data ?

    If yes ,below logic will work .

    =Sum(If([Occurance Date]<=[End Date]) And (([Occurance Date]>=[Start Date])) Then ([Element]) ForEach([Incident]))

    we can compare dates same way as in Excel !

    Regards

    Sateesh

    Add comment
    10|10000 characters needed characters exceeded