Skip to main content
Topics#Reports & DashboardsShawn Hoffman's Question
Shawn Hoffman asked in #Reports & Dashboards
Jan 29, 2021, 8:08 AM

Divide two numbers in a report

Trying to divide 2 numbers in a report, which seems like it should be simple enough with a summary formula. I played with the PARENTGROUPVAL but don't really know how to use it -- or if that's what would apply here. 

 

Worse yet, when posting my question, if I click the add link or add image button, this window goes 'grey' and freezes, so I can't add images (Any insight on that?). I'd share an image of what it looks like but...

 

That said, here's a link to the simple table I'm working with:

 

https://drive.google.com/file/d/1c8xMUmE_1UbNOHAofu8byHPGxaCbcQGb/view?usp=sharing

 

I really just need to divide the Schola Boost ($29,700) / New Software ($85,000) to find the ratio .349.

 

THANKS!
4 answers
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    Jan 29, 2021, 9:58 AM
    Your formulas should be like so then:

     

    1-Schola Boost Amount:

     

    IF(RecordType.Name="Schola Boost",Amount,0)

     

    2-New Software Amount:

     

    IF(RecordType.Name=" New Software",Amount,0)
Write an answer...
0/9000