Forum Discussion
konwes97
4 years agoFrequent Visitor
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
- AnonymousNot 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