Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
Jesper Løwe  
#1 Posted : Monday, October 26, 2015 1:58:50 PM(UTC)
Jesper Løwe
Rank: Newbie

Groups: Administrators
Joined: 5/5/2015(UTC)
Posts: 3

An analysis made in targit i need to have my probability rate calculated.

New offers displayed in a crosstable with a probabilty rate in percent shown.

I divide the probability rate with the order sum, to give me an "Estimated expected orders in DKK"

To give our sales reps a quick view the would like an average on the percentage column, but in totals i just gives me 18551%

Tried with a new calculation "average" but that wont work on a calculated column.

Average on Percent
#2 Posted : Monday, October 26, 2015 2:16:44 PM(UTC)
Rank: Administration

Groups: Administrators
Joined: 4/7/2011(UTC)
Posts: 514

Hi Jesper,

Try again with the "Average" calculated row.

Initially, it will not show up in the calculated column, but then go and edit the "Estimated expected orders" calculation. Here, you should see an option called "Calculate in intersection". This will allow you to include values from the "Average" row in the calculated column.

BR / Ole
Ole Dyring
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.