Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
But still its giving the exact result
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