Pivot Table Pro
-
- Investor
- Posts: 417
- Joined: 19 Dec 2018, 02:33
- Name: Robert McDonald
- Location: Auckland, New Zealand
- Company Name: Unicloud
- Contact:
Pivot Table Pro
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
- Site Admin
- Posts: 6222
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Pivot Table Pro
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
- Sponsor
- Posts: 214
- Joined: 14 Jan 2018, 12:55
- Name: Eberhard Rennecke
- Location: Switzerland Zurich
Re: Pivot Table Pro
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?
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})
- support
- Site Admin
- Posts: 6222
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Pivot Table Pro
Try
Code: Select all
IFNULL({10:841},0)
- rennecke
- Sponsor
- Posts: 214
- Joined: 14 Jan 2018, 12:55
- Name: Eberhard Rennecke
- Location: Switzerland Zurich
Re: Pivot Table Pro
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:
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
- Site Admin
- Posts: 6222
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Pivot Table Pro
Probably cached. Try CTRL+F5 or try to create new report or try in other browser.
- rennecke
- Sponsor
- Posts: 214
- Joined: 14 Jan 2018, 12:55
- Name: Eberhard Rennecke
- Location: Switzerland Zurich
Re: Pivot Table Pro
You are right. It's working.