Column type issue

AllenLan

There are some columns, like 'ReportingPeriod' and "Curr_Q" should be Number type while "Comments" field should be Text type.

In this case, any suggestion how to set the line item format? For example, the first line item "Global Allocation", what format to be set? either Number or Text is not correct I think.

Thanks.

andrewtye

if you're not going to have sums going on then i'd flip it so that what you currently have as line items (global allocation, etc) is a list and then reportingperiod, etc become the line items. if you're then pulling data from a source module that list you're creating will need to be a line item subset then use collect() to pull the information in the right way