Hi:
I have a transformation who has a formula for 2 KFs plus currency key, and the result goes to another KF with his currency key. The problem is that in the source DSO not always I have values for the source fields, and the DTP stops with an error. How can validate that I have all the required source filelds with "no empty values" before executing the formula in the transformation?. Any idea on how to write a "more intelligent" formula to avoid this error.?
Thanks in advance.
Hi,
You can go for routines instead of formula.The complex calculations cannot be achieved through formula in the transformation.NOERR , NODIV functions in the Bex cannot be achieved using formula instead you can go for routines.
Hope this gives you some idea.
Hi,
As Suresh and Barris have suggested it could be easily done using a routine.
Something like:
If source_fields-KF1 ne SPACE and source_fields-KF2 ne SPACE .
Result = source_fields-KF1 + source_fields-KF2
endif.
However, if you want to implement it using formula, then you can try something like this:
IF(source_fields-KF1 = Blank,0,source_fields-KF1) + IF(source_fields-KF2 = Blank,0,source_fields-KF2)
Hope this helps!
Meera
Add a comment