HANA view: merge an accountnumber to an intervall (expression editor / filter / inputparameter?)
hopefully someone has a clue.
- having 2 tables (FAGLFLEXA and FAGL_011ZC)
- a field called RACCT in FAGLFLEXA (containing Account) number)
- two fields VONKT (account from) and BISKT (account to) representing an intervall in between the account is
The problem is that I want to know to which intervall a specific account (RACCT) belongs. For every matching entry I would write the financial statement item (ERGSL) into the calculated column .
The idea is to use a expression to validate the RACCT entry is >= VONKT and <= BISKT. The expression : IF("RACCT">="VONKT", IF("RACCT" <="BISKT", "ERGSL",0),0)
Any idea why I always get an error by validating and activing this view?
Thanks in advance,