HI folks.
Now Iโve searched for an hour, so I come to you for help:
I have a DURATION -column (nuber of days) that I want to multiply with a NUMBER -column (KWH power consumption) to get the total consumation of power. Both values are variable so I cannot put a fixed value in for calculation.
It seems like APPSHEET wonโt accept Date-format to multiply with a Nubmer-format in the FORMULA.
Any workaround suggestions?
Solved! Go to Solution.
Sorry my typo error, you need to have it like HOUR([Inn1]-[Ut1])/24
You need to convert the duration as daysโฆ like ([EndDate]-[StartDate])/24. Then itโs a number and you can use it for your calculation.
Simple, but I diddnโt see it. Big thanks!!
Youโre welcome
Now I feel stupid, but where does date turn into numberโฆ?
I have:
[Date_going out] (Date format) โDateโ
[Date_going in] (Date format) โDateโ
[No of days] (Duration format) โ([Date_going in] -[Date_going out])โ
[Power consumption pr day] (Number format) โGenerated from equipment choiceโ
[Total consumption] (Number format) โ([Power consumption pr day] * [No of days])โ
I tried to change it as you wrote in [No of days]
(? format) โ([Date_going in] -[Date_going out])/24โ
But still it says " Date arithmetic expression (([Inn1]-[Ut1])/24) has an invalid operator"
Sorry my typo error, you need to have it like HOUR([Inn1]-[Ut1])/24
Now it works:)
Excellent!
User | Count |
---|---|
44 | |
35 | |
25 | |
24 | |
15 |