PQL substraction (a-b)

#1

Hi,

I’m trying to calcul the difference between to column in the same OLAP table. I used this formula :
{TMP_CDHDR_CDPOS.VALUE_OLD}-{TMP_CDHDR_CDPOS.VALUE_NEW}

but the system alway run… he never give me a results why ?
image

#2

If it’s not giving an error it might just take a wile?

Might help to aggregate or at least filter the output/component.

I’m also wondering about the ‘{’ and ‘}’ notation, fur us (CPM 4.5 on premise) we need to use ’ around table and column names.

#3

Hi, when i’m using the title of the column without the ‘{’ and ‘}’ I receive an error.
image

image
image904×131 9.35 KB

Thanks for the help.

#4

You need to use the STR_TO_INT() function to convert the values to Integers rather than String values. You cannot do mathematical calculations on strings.

1 Like
#5

When I put this formule, i’ve no result, the column become empty. Why ?
STR_TO_INT(“TMP_CDHDR_CDPOS”.“VALUE_OLD”).

#6

Hi Audrey,

the STR_TO_INT function returns null, if the input is not a number.
My solution for that would also to cast the numbers which are loaded as strings with the STR_TO_INT function so that they can substracted.

Best,
Viana