Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
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
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
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
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!
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
thank you, this was the issue