en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Allain Bøge  
#1 Posted : Thursday, July 4, 2013 10:53:30 AM(UTC)
Allain Bøge
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/15/2012(UTC)
Posts: 13

Is it correct that it is not possible to use text in a calculation ?

If i have a formula like : IF SUM(something) < 80 THEN "A" ELSE IF SUM(Something) < 95 THEN "B" ELSE "C"

I want to use it to ABC analyse the Items based on the turnover, we cannot use the color and measure agents

Kind regards

Allain Bøge
Vikan A/S
Ole  
#2 Posted : Thursday, July 4, 2013 11:04:56 AM(UTC)
Ole
Rank: Administration

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

Hi Allain,

You can only insert numeric values via formulas. The numeric value may be a fixed numeric value like "0" or "999", or it could be a numeric value as a result from another calculation. You cannot insert text.

Best regards,
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
David L. Bojsen  
#3 Posted : Sunday, July 14, 2013 9:45:10 PM(UTC)
David L. Bojsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 3/21/2013(UTC)
Posts: 19

abb@vikan.com wrote:

I want to use it to ABC analyse the Items based on the turnover, we cannot use the color and measure agents


Hi Allain

I have had the desire to do something simular earlier.
I ended up making a calculated measure in SSAS, that presented the desired text.
TARGIT has no problems displaying a measure that is text instead of a number.

However if you need to do coloring or other agents based on the value, you have to include it in a numerical format as well.
F.x. ItemType = A, ItemNumericalType = 1.
You can then include ItemNumericalType in your analysis, do whatever you want with it and hide it afterwards.

I would urge you to create a post in the TARGIT Support System, to suggest that this functionality we added to the product.
Venlig hilsen / Best regards

David L. Bojsen
Kapacity A/S

UserPostedImage

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 my employer Kapacity A/S.
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