Hi ,
In pentaho metadata ,Database - mysql
I have three tables namely account_d,card_d,organization_d , i need to get the difference btn the two dates (card_d.activation_date,card_d.closed_date) .
for that i added one column in card_d like 'date_difference' having formula as abs(DATEDIFF(date(activation_date),date(closed_date))).
I got an error as closed_date is ambiguous in where clause in the pentaho report designer. Because account_d.closed_date is also there.

please help me to sort out this.. i have been looking in this issue for 2 days. still not find the answer..