Sage 100

I have a client I am converting FRx reports to Sage Intelligence. She has an income statement trend report with period 1-12 in columns across. In FRx she was using the function to hide columns that are in a future period. She's insisting this be done in SI without having to hide or unhide columns manually. Has anyone done this in SI, and how?

You could use an if statement looking at the Period value. You'll have to manually create this, but like in column 2, you could ""if"" on every single line - if period>=2 then the calc value, else 0 then on column 3, if would be if period>=3 then the calc value, else 0 and so on.

That will have to work, and then I can add a macro to hide columns that are greater than the current period. Thanks!