Formula

[smilingjohn]

HI can someone guide me to correct this formula ?

=IF(num

  (Interval

  (Date

  (Min({$<Date={">==$(StartDate)<=$(EndDate)"},

  Department-={'Finance'} ,

  Server= P(Windows)

>}FixedDate),'YYYY-MM-DD hh:mm')

  -

  Date(min

  ({$<Date = {">=$(StartDate)<=$(EndDate)"},

  //Lead_Type={'NEW'},

  Server= P(Windows)

      >}ActaulTime),'YYYY-MM-DD hh:mm'),'mm'))< 1/24/60*30,

Count({$<Date = {">=$(StartDate)<=$(EndDate)"},

     Server= P(Windows)

   >}INstallations)

becuase under expression after >}FixedDate),'YYYY-MM-DD hh:mm')

nothing is turning into blue , Date, count are graded out and appears to be noramll text

Thanks

[jonathandienst]

Are StartDate and EndDate fields that vary from row to row in your chart/table? If so, then the set expression will not work, as the expression is evaluated once for the whole chart and not on a row by row basis.

Also remember that QV field bames are case sensitive, so INstallation is not the same field as Installation.

[smilingjohn]

But still its giving the exact result

[smilingjohn]

HI jonanthan ,

Now i want to show how many times the installation was made that is count of installations , which are less than 30 mints .

but its not working