Suffix for MySQL FOrmula Field doesn't work properly.

Post Reply
wingedpotato
Posts: 330
Joined: 16 Jan 2018, 06:10
Name: Andy
Location: Indonesia

Suffix for MySQL FOrmula Field doesn't work properly.

Post by wingedpotato »

Hello support,

I just found out that the suffix doesn't show proper result.
Screenshot_1.jpg
Screenshot_1.jpg (11.51 KiB) Viewed 698 times
One of them have, some of them don't.
Any update..?

Thank you.
User avatar
support
Site Admin
Posts: 6231
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Suffix for MySQL FOrmula Field doesn't work properly.

Post by support »

Suffix can be not used if formula return non numeric value, in this case we return just value. The solution can be just add +0 to your formula so mysql always return numeric value.
wingedpotato
Posts: 330
Joined: 16 Jan 2018, 06:10
Name: Andy
Location: Indonesia

Re: Suffix for MySQL FOrmula Field doesn't work properly.

Post by wingedpotato »

It worked...!!
Thank you very much.
Post Reply