Calculation
Posted: Thu May 08, 2008 8:30 am
Hi,
i need to calculate the aggregate current balance using 3 variables..the End of Month Date,Date opened and the current balance..expression given is
End of Month Date([YYYYDDD) - Date Opened <= End of Month Date(DDD) then
aggregate current balance / End of Month Date (YYYYDDD) - Date Opened + 1 else
aggregate current balance /end of month(DDD)
How do i implement in transformer stage..I tried Days since date but throws up error saying :Data string '%yyyy-%mm-%dd' does not match format '%yyyy-%mm-%dd': an integer was expected to match tag %yyyy.
Thanks
Reba
i need to calculate the aggregate current balance using 3 variables..the End of Month Date,Date opened and the current balance..expression given is
End of Month Date([YYYYDDD) - Date Opened <= End of Month Date(DDD) then
aggregate current balance / End of Month Date (YYYYDDD) - Date Opened + 1 else
aggregate current balance /end of month(DDD)
How do i implement in transformer stage..I tried Days since date but throws up error saying :Data string '%yyyy-%mm-%dd' does not match format '%yyyy-%mm-%dd': an integer was expected to match tag %yyyy.
Thanks
Reba