Column type issue

AllenLan
AllenLan
edited November 27 in Modeling

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.

1.jpg

Answers

  • andrewtye
    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

  • Dikshant
    Dikshant

    Depends if it is going to be an input line item or an formula driven. Assuming these are line items, and if you need to refer it from different module/ line item, keep the format same as source module/ line item.

    If it's an input line item, then text makes more sense as it's a comment field.

Categories