Forum Discussion

konwes97's avatar
konwes97
Frequent Visitor
4 years ago

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

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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi konwes97 ,

     

    Have trouble to follow.

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

     

    Best Regards,

    Jay