topic Re: datedifference multiple costs per minute - how to convert to money for map in App Development

datedifference multiple costs per minute - how to convert to money for map

LenCa — Thu, 19 Sep 2019 06:09:42 GMT

in my load script I have two datetime fields. I am getting the difference between those fields in minutes. I multiple the difference by costs per minute.

On the map I can see costs for each location, the size of the point bubble depends on the costs. But I can see there in tooltips that the costs are for example 0,2m, 15m and so on. It looks like it's showing it in minutes. I tried two different ways how to calculate the costs. Any suggestions what I could try or why is this happening? thank you

This is what I tried:

Money#(Num(OlderDate - NewDate)*0.067) as Costs

Num(Interval(OlderDate- NewDate,'mm'))*0.067 as Costs

Re: datedifference multiple costs per minute - how to convert to money for map

DavidM — Thu, 19 Sep 2019 07:14:58 GMT

Maybe only change to Num# is needed?

Money#(Num#(OlderDate - NewDate)*0.067) as Costs

Or maybe is the number with too many decimals? In main script 'm' behind the number means -3 zeroes

Re: datedifference multiple costs per minute - how to convert to money for map

LenCa — Thu, 19 Sep 2019 07:18:08 GMT

Thank you. I will try to change to Num.

There is a big probability that the numbers have many decimals, I didn't know about 'm' meaning -3 zeroes, thanks for telling me!

Re: datedifference multiple costs per minute - how to convert to money for map

DavidM — Thu, 19 Sep 2019 07:25:25 GMT

In that case it is probably number, just question of formatting:

in main script there is variable: Set NumericalAbbreviation and in that you can find number (which is 10 squared by) and the abbreviation. 10 squared by -3 is m - you can change that

Re: datedifference multiple costs per minute - how to convert to money for map

LenCa — Tue, 15 Oct 2019 07:08:28 GMT

thank you, this was the issue