on 07-13-2015 2:24 PM
Hi SCN,
hopefully someone has a clue.
The situation:
- 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,
Jonathan
Why don't you just join on RACCT to be in between those two columns?
Either plain SQL or analytic view lets you do that.
- Lars
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 | |
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.