Hello,

I am trying to write a define that will force a column to always equal a certain value.

my example is this:

When Current_week = 0 then current_week name

So basically every time it's the current week, the whole column says the week name. I can't get it to work properly. It always puts the one or two records for the current week as the name and the rest of the rows blank.

What I want to see is this:

item current_week week name value
9999 0 Week 2 42
8888 1 Week 2 54

Can anyone help?

This message has been edited. Last edited by: <Kathryn Henning>,

Can you post the code ?

What code do you wish to see? I am doing this as a define in IA.