en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
LESELLIER  
#1 Posted : Tuesday, October 13, 2015 2:22:40 PM(UTC)
LESELLIER
Rank: Member

Groups: extranet\Customer
Joined: 11/19/2014(UTC)
Posts: 8

Hi all,

Does anybody know how to apply a cross-multiplication in Targit based on remaining time before the end of the year.

Eg: My sales until end of Sept are $1,000, at the end of the year they may be $1,000/9*12 = $1,333.33.

My question is how to get this 12/9 in Targit...

Any clue?
Steffen Davidsen  
#2 Posted : Wednesday, October 14, 2015 7:16:05 AM(UTC)
Steffen Davidsen
Rank: Advanced Member

Groups: extranet\Customer
Joined: 7/8/2014(UTC)
Posts: 28

Originally Posted by: LESELLIER Go to Quoted Post
Hi all,

Does anybody know how to apply a cross-multiplication in Targit based on remaining time before the end of the year.

Eg: My sales until end of Sept are $1,000, at the end of the year they may be $1,000/9*12 = $1,333.33.

My question is how to get this 12/9 in Targit...

Any clue?


One possible solution would be to add a month dimension as columns, then do a custom calculation as a single column. Name this "Estimated sales this year" (or something like that) and use:

sum(all, 0, m1) / count(all, 0, m1) * 12

Then go in to the visibility settings and hide month values.

This however requires the y-axis (columns) to be empty for other dimensions in the original crosstable.

Best,
Steffen
LESELLIER  
#3 Posted : Thursday, October 15, 2015 10:08:54 AM(UTC)
LESELLIER
Rank: Member

Groups: extranet\Customer
Joined: 11/19/2014(UTC)
Posts: 8

That's a good hint.

It works in my case as I can use a simple table.

Thank you!

@Targit teams: making time reference available in calculation would be a nice improvement! ;)
Ole  
#4 Posted : Thursday, October 15, 2015 10:56:27 AM(UTC)
Ole
Rank: Administration

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

Lesellier - feel free to suggest ideas for TARGIT improvements here: targit.uservoice.com

Edited by user Thursday, October 15, 2015 10:57:02 AM(UTC)  | Reason: Not specified

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