Link Table

[#1]

Hi.

I created a linked table with field YearMonth as my key field.

I have in my script a calculated filed that tells the Qtr of a specific month.

For Example:

Date               Month     Qtr

06/15/2014     06            2

When I chose the Qtr '4' and not months 10,11,12

the data displayed is not the same.

I assume it's because the Linked Table.

What could be the result for that?

Thank You.

[Anonymous]

Hello, 

Can you send a picture the associative model?

[#3]

What to you mean associative?

[Anonymous]

It is the model that is generated by relating the tables. You can see it by doing ctrl + T.

[#5]

I load my table from sql

select

  month(line_date),

quarter = if month> 9 then 'q4' else

                if month > 6 then 'q3' else

               if month >3 then 'q2' else

               if month > 0 then 'q1' else ' error!'

endif end if endf endif