PDA

View Full Version : Calculated Business Column based on other columns



mh_br
03-26-2008, 03:25 PM
Hello

I have a date information that is stored separately as characters in my Database - birthdate_year, birthdate_month, birthdate_day.

But I need that information in a Date type. I am trying to do that through a Calculation formula in my Buisness View, but I can't figure out the correct formula - ( I think I am not passing the parameter correctly). Follow is the formula I entered in PME.

DATEVALUE("[BC_STUDENTS_BIRTHDATE_YEAR]+[BC_STUDENTS_BIRTHDATE_MONTH]+[BC_STUDENTS_BIRTHDATE_DAY]")

Please, any input about this is greatly appreciated.
Thanks

MattCasters
03-26-2008, 05:03 PM
http://wiki.pentaho.org/display/PentahoDoc/02.+Pentaho+Metadata+Formulas

As you can see, multi-table calculations have been only very recently added.