Function Error

Looker Q&A Looker
1

Do you know why a function returns an error, but not all the time?
I was working with “Floor”, I tested it and returned a number, then I added another calculation and then when I clicked on Run I received the message:

Unknown function “Floor”

But it was working a minute ago

2

Hi WChepe,

Note that functions are case sensitive - could it be that you used it in lower case the first time and camel case the second?

All functions should be typed in lowercase.

Best,
Maddie | Redkite

4 Likes