Pivot Table Pro

[rmcdonald]

In pivot table pro field settings when we have a mysql formula field it is not recognising the field as a number and therefore only sets it to be counted - when we need to have the mathematical functions available to sum etc

[support]

Formula need return number or zero. If it returns empty text or number with comma then app things it's string and that is why there is no SUM function.

[rennecke]

Hello.
I've a similar issue and can not find the failure:
I have a function calculating the SUM of a numeric field [785].

This function is than used in a MySQL-formula:

As I thought, that maybe {10:841} gives NULL or empty string ("") back in case there is no link in [841] I tried the following as well:

Code: Select all

IF({10:841}=NULL,0,{10:841})

Code: Select all

IF({10:841}="",0,{10:841})

But no effect. List shows empty value instead of 0 % (see first row).

I always get only COUNT in the Pivot Tables Pro field selection:

What am I doing wrong?

[support]

Try

Code: Select all

IFNULL({10:841},0)

[rennecke]

Thanks for the hint.
At least the MySQL-Formula is working. I get a value for all:

But the field selection in Pivot Tables Pro is just saying COUNT:

[support]

Probably cached. Try CTRL+F5 or try to create new report or try in other browser.

[rennecke]

You are right. It's working.