in the moment i am stucked when it comes to calculation of summed amounts. The snapshot describes my proble quite good. I have filtered opportunities with historical data. There is a snapshot column where there is the historical amount per salesperson snapshotted on first of month. this summed historical amount (marked in red) i want to divide by the amount of the right column (marked in blue) to get a hitrate in percentage. If I add a formula like i posted in the second snapshot it only calculates the percentage of amount and historical amount within one column. How can I make it happen that I have access to the other column? Hope you get what I described.
Thank you so much for your support.
Manuel
1 个回答
Hi Manuel,
Sorry for the inconvenience. In case you don't receive a response here, may I also suggest joining the Reports & Dashboards group below to collaborate with the experts for best practice and advice.
https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000001rDKCAY
Hope that helps.
Regards,
Jayson
