en
Welcome Guest! To enable all features please Login or Register.
Options
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: extranet\Forum
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
Ole  
#2 Posted : Monday, October 26, 2015 2:16:44 PM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 320

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
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Users browsing this topic
Anonymous
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.

Notification

Icon
Error