1 Reply Latest reply: May 15, 2014 9:59 AM by Grant Perkins RSS

    Help with repeated fields

    s-roland _

      Hello everyone.

       

      I have a simple question.

       

      My data looks as follows:

       

      [font="courier"] 

        11823                   521,30  

        11823 510253                69,60

        11823 510115                69,60

        11823 510233                69,60

        11823 510127                69,60

        11823 510119                69,60

        11823 510132                69,60

        11823 510142                69,60

        11823                       34,10

        10593                 5.228,45   /font[/quote]The first and the last figures are debit, while the indented figures represent the credit.

       

      My idea was to identify the type of the numbers by the position of the comma.

       

      And there is my problem:

      In the table-view Monarch appends the same debit figure until it changes, even though the field should be left empty.

       

      I also do not see a chance to avoid the problem via the summary-function "hide duplicate entries" (as stated in the FAQ), as duplicate entries are allowed, as you can see in the example above.

       

      Does anybody have an idea?

       

      Thank you very much in advance.

       

      Sebastian

        • Help with repeated fields
          Grant Perkins

          Sebastian,

           

          Have you created a template that selects every row as a detail row (which would be the right thing to do) or are the debits set up as append traps?

           

          If they are append traps you will get the repetition for each detail row.

           

          If the debits are detail then check the field properties in the table window. The exact terminology will depend on the version of Monarch you are using but there is an option under the 'General' tab to fill empty cells with the previous value from that cell or to leave them blank. It sounds like this may be set to 'fill' and you nedd 'blank'.

           

          In the summary the idea works the other way around and normnally you would probably want to show all the keys ion the summary definition for clarity, but sometimes for output to a 'report style' it is easier to read with duplicated or repeated values suppressed from the disply, although they will still exist in the summary calcualtion tables.

           

          I hope this is somewhere close to helping you.

           

          If I have completely misunderstood I apologise - tell me where I go wrong and I will think about it some more ...

           

          Best regards,

           

           

          Grant