Convert decimal to a whole number

[John Currey]

Hi, 

I'm trying to calculate ATS winning percentage. I have this:

round(tS(ats margin>0)/(tS(ats margin>0)+tS(ats margin<0)),2),tS(ats margin>0),tS(ats margin<0),R(team)@team and season=2022 |

https://s3.sportsdatabase.com/NFL/query.html?sdql=round%28tS%28ats+margin%3E0%29%2F%28tS%28ats+margin%3E0%29%2BtS%28ats+margin%3C0%29%29%2C2%29%2CtS%28ats+margin%3E0%29%2CtS%28ats+margin%3C0%29%2CR%28team%29%40team+and+season%3D2022+%7C&submit=++S+D+Q+L+%21++

It works fine. However, I prefer the percentage appear as a whole number, so I multiply by 100. It returns the running values in a list. 

https://s3.sportsdatabase.com/NFL/query.html?sdql=round%28tS%28ats+margin%3E0%29%2F%28tS%28ats+margin%3E0%29%2BtS%28ats+margin%3C0%29%29%2C2%29*100%2CtS%28ats+margin%3E0%29%2CtS%28ats+margin%3C0%29%2CR%28team%29%40team+and+season%3D2022+%7C&submit=++S+D+Q+L+%21++

Even and added layer of parentheses doesn't help. 

https://s3.sportsdatabase.com/NFL/query.html?sdql=%28round%28tS%28ats+margin%3E0%29%2F%28tS%28ats+margin%3E0%29%2BtS%28ats+margin%3C0%29%29%2C2%29%29*100%2CtS%28ats+margin%3E0%29%2CtS%28ats+margin%3C0%29%2CR%28team%29%40team+and+season%3D2022+%7C&submit=++S+D+Q+L+%21++

I think it's a bug. 

Thanks. 

[Joe Meyer]

John and SDQL API Friends,

math outside of an aggregator makes a 'running' aggregator (see http://SDQL.com/aggregator.html).

To get what you are looking for, just move the `100*` inside the aggregator, like this:

int(tS(100*(ats margin>0))/(tS(ats margin>0)+tS(ats margin<0))),tS(ats margin>0),tS(ats margin<0),R(team)@team and season=2022 |

https://s3.sportsdatabase.com/NFL/query.html?sdql=int%28tS%28100*%28ats+margin%3E0%29%29%2F%28tS%28ats+margin%3E0%29%2BtS%28ats+margin%3C0%29%29%29%2CtS%28ats+margin%3E0%29%2CtS%28ats+margin%3C0%29%2CR%28team%29%40team+and+season%3D2022+%7C&submit=++S+D+Q+L+%21++

 

Best regards,

Joe Meyer

Sports Database LLC

--

---
You received this message because you are subscribed to the Google Groups "SDQL API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdqlapi+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/32de37cc-45a6-4045-bb7e-a172052d1db1n%40googlegroups.com.

[John Currey]

Thanks, Joe.