cancel
Showing results for 
Search instead for 
Did you mean: 

How to use Integer Attribute in Attribute As a Key Figure?

prasad_mandre
Participant

Hello Experts,

I am working on a requirement wherein I would like to use Attribute value in Key figure for a comparison. Below is our requirement -

I would like to raise an alert when attribute value(say X) is more than 7. For this I am bringing attribute value in KF and trying to use that KF in Alert key figure calculation. I tried two ways to achieve this-

1. Firstly,I tried to define Attribute as Key Figure but as attribute X is set up as Integer and not as decimal, I couldn't use attribute X as key figure. I cant change data type of attribute so this option ruled out for me.

2. I tried to use attribute X as constant in key figure calculation using two single quotes to compare X(e.g.. If(''X'' > 7, 1,0) but I am not getting any output. Everything is setup at Product Location level here.

Am I missing something here ? Any idea how to achieve this objective using some other way?

Thanks,

Prasad

Accepted Solutions (1)

Accepted Solutions (1)

piyush_parekh
Active Contributor

Hi,

Since your attribute type is integer, use double quote instead of two single quotes for comparison. Refer ADJUSTEDPRODUCTION, for instance in which an attribute FROZENHORIZON (Data Type: Integer) is used in key figure calculation. On similar lines, you can design your calculation definition.

Regards,

Piyush

prasad_mandre
Participant
0 Kudos

Thanks for the update Piyush. I tried using double quotes. It worked. Data is still not flowing in. I will check it further.

Thanks,

Prasad

Answers (0)