topic Re: Above Function in App Development

Above Function

davidvikings198 — Thu, 04 Oct 2018 23:58:04 GMT

Hi All,

I have the following information in a table:

Sys	if(IsNull(above(Sys)),0,Sys-Above(Sys))
8/24/2018 8:27	0
8/24/2018 8:51	0
8/24/2018 8:51	0
8/24/2018 8:59	0
8/24/2018 9:32	0

I have the formula I am using where I want a running total but it is not working. I would like it to show as time like:

00:00:00

00:00:09

00:00:01

00:00:08

00:00:33

I hope this makes sense. All suggestions would be helpful.

David

Re: Above Function

petter — Fri, 05 Oct 2018 06:30:08 GMT

It works fine for me:

Are you sure that the Sys field is really a date field? If the values in the Sys field is not accepted as dates they will be text and they might look ok in a table but calculations with them will not work.

Re: Above Function

petter — Fri, 05 Oct 2018 06:37:41 GMT

Here with a "running total":

Re: Above Function

davidvikings198 — Fri, 05 Oct 2018 11:54:17 GMT

Thank you Petter. I did not realize I posted it in two places. Was late and must have typed the add wrong. Anyways I thought I was correct. I am checking if it is a true date field but mine is now showing 00:00:00 which makes me think it is a text field.

David