vustom measure = The first argument for "/" must be a Number, but a String was given

[shakermakerk]

hey guys, I have a custom measure that sums quantity based on product type being x. It works fine. But then when I try and do a table calculation using the custom measure I get the message :

The first argument for "/" must be a Number, but a String was given”

any ideas?

[shakermakerk]

apparently this is a bug 

[nivev18]

does anyone know when this bug will be fixed? 

[shakermakerk]

Just ignore the error the calculation comes out okay. Looker is really full of bugs and the customer support is terrible 😞

[nivev18]

@shakermakerk bummer, ok thanks for the tip! 

[mukulmunjal-164]

Hi @shakermakerk,

Greetings!

This is Mukul and I am a TSE at Google (Looker DCL support).

Thank you so much for pointing out this bug, we have just fixed it and it should no longer be there in latest version of looker (22.2.30+).

If you’re facing this issue after upgrading to latest version, kindly let us know and we will certainly look into it.

Best, Mukul