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

[konwes97]

Hi guys,

Unfortunately, there is a problem for me with Log in the column. Namely, my function looks as follows:

LOG = IF(NOT(ISBLANK('Same'[CPM])),LOG(1 + 'JBI'[ALN]),BLANK())

And I have Error. The data problem is definitely not there. The only solution I found is that instead of 1 in the log function I add 1.000001. Then yes the function works but I have no precise results.

Thank you very much.

[v-jayw-msft]

Hi @konwes97 ,

Have trouble to follow.

Please share some sample data and expected result so that we could test the formula.

Best Regards,

Jay