cancel
Showing results for 
Search instead for 
Did you mean: 

sign Key figure based on characteristic value

former_member484977
Participant
0 Kudos
293

Hi experts.

Is there anyway to change the sign of a key figure based on a characteristic value?

i´ve joined two sources and i can see the total weight of a qty invoiced, but when the invoice ys a credit note i want to see the net weight with negative sign.

Is this possible?

Looking forward to hearing fromyou.

BR

View Entire Topic
former_member81526
Participant
0 Kudos

Good morning Luis,

I think this is possible if I understood correctly, although you would need to create several intermediate key figures:

Key Figure 1: restricted to Invoice = Credit Note

Key Figure 2: calculated as -2*KF1+NWeight

Best regards,

Ana Gándara

former_member484977
Participant

Hola Ana.

Muchísimas gracias, era justo lo que buscaba.

Saludos.