on 06-27-2016 9:39 PM
Hi,
I had the same problem.
What helped ?
-quotation of all the Elements with " in the formular
AND / OR
-no BLANKs in the isnull and if Clause
For ex:
IF(isnull("MT_SPLITTOBR"),1,"MT_SPLITTOBR") * "BT_AMOUNT" / "BT_ROWCOUNT"
Does not contain Blanks between the starting "IF" and the closeing bracket ")"
Best Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Rithika
Can you do a data preview with a filter on the TO_DATE field to get the null values?
Please let me know if you are able to see those rows having TO_DATE value as '?' after doing this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please check data type of To_Date.
Regards,
Chintan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Your formula works perfect for me . Checked with different date fields, all works.
What is your HANA revision ? I also tried another version, but could not find a problem .
if ( isNull ( daydate ( "DATE_SQL") ) ,'PRESENT','')
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Rithika,
please can you share your view definition? And on what SPS level you are working. Trying your expression on an SPS10 and SPS11 system works find for e.g. attribute and calculation views.
@Astrid: the space (if there or not) is not really relevant.
Regards,
Florian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
have you tried removing the space between "(" and "isnull"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.