如何将范围为0.0,1.0的浮点小数点规范化,使其成为介于最大值和最小值之间的数字?规范是正确的词吗?跟着我想做的事情。如果我输入0.799999并且范围是0到10,那么输出应该是8。如果我输入0.555并且范围是0到20,那么输出应该是11。 // Return value normalised between min
sum(charge) as total_cash (where transactioncode in ('CASH')), calculated total_payments/12 as avg_monthly_payments,
calculated total_cash/12 as avg_cash_