Multiplying a column by a constant (converting Metric to Imperial/US)

AppSheet AppSheet Q&A
1

Rainfall graph.png
Rainfall graph.png1917×938 208 KB

Hello

I’m using quickchart and all my rainfall data is in millimetres. I know I can make VCs with the conversion 0.03937*[Monthly Rain] to put my values in inches, but I’m hoping to avoid adding lots of VCs and instead do it within the Quicksheet expression.

How do I multiply a slice of a column Statistics of the last year[Monthly Rain] by 0.03937 ? I’ve gotten this far but don’t know how to multiply each item in the list by 0.03937

Select(Statistics[Monthly Rain],AND([Month-Year] <= EOMONTH(TODAY(), 0), [Month-Year] > EOMONTH(TODAY(), -12)))

Cheers and thanks

Leon

2

You don’t, you add a column.

3

Thank you Marc

I ended up doing it in the underlying Google Sheet.

Cheers!