Rukovoditel Support Forum

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

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.

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: 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?

Try

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:

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

You are right. It's working.