I have a bit of a challenge (then again, maybe it's easy for someone here).
On my application's welcome page, I want to add a text object that shows the number of accounts that are Open, "and counting", i.e. I want the number to increase (more or less) at the speed it does in reality.
The module is only reloaded every morning, so the data is 100% correct then. On average we open 600 accounts a day, so that is (more or less) an account every one minute (if I just count the hours in the work day).
So I can do this using the now() function, and manipulating it to a number value that increases at the above speed. Something like this:
=num(Count({$<[Account Status]={'D','N','U','A'}>}[Account No])+(right(round(num(time(now()))*1000,2),3)-300),',##0')&' Open Accounts.... and counting'
But I do not want to use the now() function because I do not want to cause performance issues.
Any idea how else I can increase the value of an expression with one,every minute or so?
