IF Field Formula in Custom Query Builder

Dear experts I am trying to get the server time for a particualr page on different Time stamp and with custom query builder its very easy to get it, I used the below field Alias and field Formula

 

time_stamp

Page Name

Server Time - SUM(tot_server_time/1000)/SUM(total_hits)

 

Now i want to schedule this report and show the timestamps and server times that are breaching the threshold 50 sec.I dont know how to use the IF case inside the formula field and i cant find a good documentation for it on BAC documentation. Please help I dont know if this below formula will work still i dont know the last two Arguments in the IF syntax

 

IF(SUM(tot_server_time/1000)/SUM(total_hits),>,50,?,?)

 

what should i add there? or am i doing it in wrong way? Please let me know thanks

 

 

Parents Reply Children
No Data