I'm creating a report taht must show ROI and opp close-won amount in sandbox
My actucal cost in campaign is $100
My close won opp has amount $200 , but the ROI field shows -100%.
Please help me to figure out what's wrong.
7 answers
Find the object that you're reporting on (is it campaign?), and open the fields and relations tab. It should be in there.
With that being said, if you've never played with the object manager before, you really want to go on a sandbox first - or have someone experienced helping you out.Dear Amnon,
I have the access right to access Object Manager, where do I see field definition of ROI in Object Manager?
There are no ROI label in our organization.If this field is calculated automatically, then it most likely is. You'll need to look in the field definition, in Setup->Object Manager. If you don't have access to that, you'll need to ask your system administrator. Dear Amnon,
I don't really know if it's a formua field or not, where can I check it?
The following pic is choosed by : add column > campaign : general > ROIDear Amnon,
I didn't use any formula, the way I get roi field was shown as below picture
1. I choose select column
2. find ROI and drag it out
