Help with Dual function

[hopkinsc]

Hi all,

i have the attached qvw/excel sheet which load in report headings for a accounting GL dashboard.

the excel has 2 reports listed

     Balance Sheet

     Income Statement

with the headings for each report and the sequence

when loaded in the Income Statement is using the descriptions for the balance sheet and i am unsure why.

I know it is to do with the dual function but was wondering if anyone could get this working?

[mjm]

Hello hopkinsc,

I believe I understand what you are trying to achieve, but the dual function is basically used to assign a numeric value to a string, in order to sort it. This is often used for assigning a day number. From my understanding this is not what you want to achieve.

I would suggest using a simple concatenation like [Rpt Line Desc] & '-' & [Line Seq] as [Rpt Line Desc3]

I have attached an example qvw which may help.

If this helps, please mark this as answered and complete.