Forum Discussion
An argument of function 'ROUND' has the wrong data type or the result is too large or too small.
I'm not understanding why this error is coming up since none of the input values are numbers and the values are not too small. LTV Calc = If(tbl_kpi[LTV Calc Flag]="Exclude",0, round((tbl...
Hmm.. wierd... any nulls in the columns? Are all the columns number or decimal type?
also try using DIVIDE so instead of the (Column1-Column2)/(Column3) try ROUND(DIVIDE((Column1-Column2),Column3,0),3)
If thats not it I have no idea.
Greg