on 09-04-2020 10:26 AM
Hi,
in your formula at the end the both else values must be from the same data type as your target field.
I'm not user what the data type is (int, float, ...).
Please adjust the formula like:
Before: ... if("0CONF_DATE" = "0DSDEL_DATE", "0CNFQTY", ''), '')
After, for target data type INT: ... if("0CONF_DATE" = "0DSDEL_DATE", "0CNFQTY", 0), 0)
in case of a DEC or FLOAT data type may be 0.0 must be used instead of 0.
Torsten
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I assume the target field (0pqcasrqpu) is a key figure.
In the ELSE condition of your IF statement you are using an initial string ''.
I assume HANA expect a number. Could you change the two ELSE condition '' to 0.
And try activate / execute again.
Torsten
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.