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

[leonsteber]

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 

[Marc_Dillon · Accepted solution]

You don't, you add a column.

[leonsteber]

Thank you Marc

I ended up doing it in the underlying Google Sheet.

Cheers!