(Duration * $) to get a fee

Ask for Help
1

I’m trying to use a math column to calculate a storage fee ($0.10 per day per item) allowing the user to input date and item count. The math column won’t allow me to format $ and forces duration due to using dates. Am I missing something?

2

the whole column needs to be in the same format

1 Like
3

So how do I turn (now - 30 days ago) into “30” instead of 720:00:00?

4

If i was in your situation i will use google sheet to convert date to be number then i will use the math. You might need to dublicate the currency column and use the dublicated column as number too. Try

6

Use either trunc or round in your math formula (this behaviour changed a few months ago)

3 Likes
7

Thank you!

8

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.