Convert decimal to a whole number

15 views
Skip to first unread message

John Currey

unread,
Jan 1, 2023, 2:59:02 PM1/1/23
to SDQL API

Joe Meyer

unread,
Jan 2, 2023, 10:46:54 AM1/2/23
to sdq...@googlegroups.com
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 |

 
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

unread,
Jan 2, 2023, 5:10:57 PM1/2/23
to SDQL API
Thanks, Joe. 
Reply all
Reply to author
Forward
0 new messages