is it possible, with saved search, to perform rati...
# suiteanalytics
r
is it possible, with saved search, to perform ratio analysis? e.g. group by period then revenue per headcount, as an example. I want to perform division on the SUM of a couple of formula(numeric) s. I would use an OUTER APPLY if I was in SQL. Thanks in advance
g
check suite answers 50479. Shows how to divide two columns that are summed. While it uses fields, i've successfully done it with formulas instead of fields.
r
Wonderful recommendation. After about 30 minutes of cage fighting with this beast, I have got it working. Thanks so much for the guidance.
g
Glad it's working for you!
r
I was close (but not nearly close enough).
k
Another fun one is ratio to report
That's a hard one to use though