7 Replies Latest reply: Jul 29, 2014 9:54 AM by Wolfgang Mohr RSS

    Circular Reference, $Sync

    Wolfgang Mohr

      Hi Folks,
      maybe somebody holds the key for my Problem:
      Auftrag: Actual (sum(MengeVK*PreisVK))
      Kunde: Target (ZMUmsatz (figure per month)
      MasterCalendar to Combine Dates, see .jpg

      The Task is to compare Actual of a certain period (Monat) with the Target of a certain Period (ZMZDatum).

      This reflects on a specific Kunde AND with a specific Date.

      By all means, I am running on a circular reference or a $Sync when working out the red arrow??

      Anybody any idea or best practice? Any technique to bring things together?

       

      Thanks in advance,

      Wolfgang

       

      (time being I work with two calendars, which means always to select the correct period in both calendars,

      Actual and Target)

        • Re: Circular Reference, $Sync
          Friedrich Hofmann

          Hi Wolfgang,

           

          well, your picture confuses me a bit - as long as fields are differently named, they should not be linked by QV, the contents are irrelevant. You might have to work with the AS option to give alias_names to some fields to avoid that - and it would be a good idea to have one master_calendar where you can select your periods.

          HTH

           

          Best regards,

           

          DataNibbler

          • Re: Circular Reference, $Sync
            Tobias Klett

            Hi Wolfgang,

             

            it seems to me you have two different types of Datum. One for the Auftrag and the other for the Kunde. So it has probably a different meaning to select Kunden with a ZMZDatum or to select Auftrge with a Datum.

             

            Therefore you need to calendars.

             

            Hope this helps

            Tobias

              • Re: Circular Reference, $Sync
                Wolfgang Mohr

                Hi Tobias,
                indeed this is the case. Therefore I work with two calendars. However I am still with a Little hope to combine both in a MasterCalendar.

                Thanks your Input!

                Wolfgang

                  • Re: Circular Reference, $Sync
                    Tobias Klett

                    Hi Wolfgang,

                     

                    I think it is logically not possible. What is the meaning of ZMZDatum?
                    When you select it you get all the Kunden which have this ZMZDatum an their Aufträge no matter which Datum they are.
                    On the other hand when you select a Datum you get all the Aufträge no metter wichich Kunde they have or which ZMZDatum the Kunde has.

                     

                    This is technically different an therefore cannot be united.

                     

                    Das Eine entspricht einer Auswahl von Kunden und das Andere einer Auswahl von Aufträgen. Das läßt sich genausowenig zusammenbringen wie Auftrags-, Lieferungs- und Rechnungsdatum. Ich habe in solchen Fällen auch schon eine abgehängte Kalendertabelle erzeugt in der die Anwender selektieren können und die Selektionen per Set Analysis in die Formeln übenommen. Oder gar dynamische Listboxen deren Feldnamen mit einer Variablen auf unterschiedliche Kalender geht; z.B. Monat_$(KalenderTyp).

                    Hope this helps
                    Tobias

                • Re: Circular Reference, $Sync

                  Hi,

                   

                  the table customer should only be a master data (Stammdaten) table, i think. there should not be any transaction data in it, so i would suggest, to concatenate (depending on your data) the zmdatum and zm umsatz fields to your aufträge and rename zmdatum to

                  zmdatum as Datum