An argument of function 'ROUND' has the wrong data type or the result is too large or too small.

[nicktayl]

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_kpi[Combined Loan Amount]-tbl_kpi[Construction Holdback - Risk Basis]-tbl_kpi[Interest Reserve]-tbl_kpi[X-Collateral _Construction Holdback])/
tbl_kpi[LTV As-Is],3))

An argument of function 'ROUND' has the wrong data type or the result is too large or too small.

It works fine without the "ROUND" function:

[Anonymous]

I had the same error due to infinity. when you cannot divide by 0. added DIVIDE and that worked.

[Anonymous]

Hi,

Try to make it like this ROUND(IFERROR(...,0))

[Anonymous]

I had the same problem which appeard out of nowhere. Yesterday it worked and today it doesn't.

Here is the solution...

In Qeury editor:

1. replace "null" (without quotation marks of course) values with 0

2. change the column type to "Whole number". I had "Decimal number" and somehow it did not work.

[dearwatson]

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