Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.
Moderator: Moderators
by mrkrause » Thu Mar 10, 2011 5:31 am
Hi,
i created a new simple test statistic.
As format expression i can enter 1+3 or 4 *4 or 4-2 and its working fine, but when i put any division like 3/2 - it says expression not valid.
What iam doing wrong?
(Same problem with the value expression too btw.)
Thanky You
-
mrkrause
-
- Posts: 2
- Joined: Thu Mar 10, 2011 5:19 am
by mrkrause » Thu Mar 10, 2011 5:49 am
after 2 hours! I figured it out finally
2/2 not workin vs. 2 / 2 working - see the differnce ?
is there a reason why to have whitespaces before and after the / ?
why is it only with the / and not the other operators like + or * , very confusing?
Regards
-
mrkrause
-
- Posts: 2
- Joined: Thu Mar 10, 2011 5:19 am
by kraada » Thu Mar 10, 2011 12:45 pm
Our statistics validator is a bit picky when it comes to division unfortunately - you do need to include the space on either side. In general, it's probably better practice to keep a space on either side of the math operator - if nothing else it's just easier to read.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests