# Modus: Anpassen \[Apply refraction to new column\] **URL:** \ **Category:** Product Ideas\ **Created:** [August 5, 2019, 6:12am UTC](https://pug.phocassoftware.com/t/modus-anpassen-apply-refraction-to-new-column/1189 "2019-08-05T06:12:57Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Muecke](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/muecke/32/505_2.png) [@Muecke](https://pug.phocassoftware.com/u/Muecke)\ **Post date:** [August 5, 2019, 6:12am UTC](https://pug.phocassoftware.com/t/modus-anpassen-apply-refraction-to-new-column/1189/1 "2019-08-05T06:12:58Z")
[EN] Hi, Internally we have key figures with which we work, which I have to calculate again and again. Phocas should do that for me! But it is very cumbersome. Idea: Mode - Customize Use the result of a column to calculate a new column. In Excel it looks like this: Column A: Sales Column B: Internal value 1 Column C: Internal value 2 Column D: Internal value 3 A2: 500,- € B2: =A2_0.3 C2: =A2+B2_0.08 D2: = ((A2\*0.5)+C2)-B2 In Phocas, I have to re-enter every value I’ve already calculated and re-enter the values for the calculation. It would be nice if you could access other columns in the calculations. For example like in the picture. I would be very happy to receive your feedback Greetings Mücke Translated with [DeepL Translator | World's Most Accurate Translator](http://www.DeepL.com/Translator) [DE] Hi, Intern haben wir Kennzahlen mit denen wir arbeiten, diese muss ich immer wieder berechnen. Das soll Phocas für mich machen! Ist aber sehr umständlich. Idee: Modus - Anpassen Ergebnis einer Spalte für die Berechnung einer Neuen Spalte zu verwenden. Im Excel sieht das so aus: Spalte A: Umsatz Spalte B: Interner Wert 1 Spalte C: Interner Wert 2 Spalte D: Interner Wert 3 A2: 500,- € B2: =A2_0,3 C2: =A2+B2_0,08 D2: = ((A2\*0,5)+C2)-B2 In Phocas muss ich jeden schon berechneten Wert neu eingeben und die Werte neu angeben für die Berechnung. Es wäre schön wenn man in den Berechnungen auf andere Spalten zugreifen kann. Zum Beispiel so wie im Bild. Über ein Feedback würde ich mich sehr freuen Gruß Mücke ![Apply%20refraction%20to%20new%20column](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/efcf74876c4dbb6e4a5cc810a801779d11019503.png) ---
**Author:** ![StuartH](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/stuarth/32/394_2.png) [@StuartH](https://pug.phocassoftware.com/u/StuartH)\ **Post date:** [August 5, 2019, 8:56am UTC](https://pug.phocassoftware.com/t/modus-anpassen-apply-refraction-to-new-column/1189/2 "2019-08-05T08:56:43Z")
I agree, it would be useful to use previous results in other columns - using the @ is a good suggestion, though I presume this will be a restricted reference due to the @ mentions elsewhere in the system. Using square brackets though should be sufficient. There is another suggestion on about storing common calculations from totally separate reports as a name (or Function) too. ---
**Author:** ![Muecke](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/muecke/32/505_2.png) [@Muecke](https://pug.phocassoftware.com/u/Muecke)\ **Post date:** [August 5, 2019, 8:21pm UTC](https://pug.phocassoftware.com/t/modus-anpassen-apply-refraction-to-new-column/1189/3 "2019-08-05T20:21:01Z")
What can the @ be used for ? How likely is it that the end developers will look into the forum and implement some of the ideas? How do I get to know about such a change? Newsletter? ---
**Author:** ![StuartH](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/stuarth/32/394_2.png) [@StuartH](https://pug.phocassoftware.com/u/StuartH)\ **Post date:** [August 5, 2019, 9:18pm UTC](https://pug.phocassoftware.com/t/modus-anpassen-apply-refraction-to-new-column/1189/4 "2019-08-05T21:18:49Z")
Developers and Product Managers do look at the forum so it’s useful to post things here. If it’s mission critical you should raise it with your account manager also as they may know of some other customer whose had a similar problem. @mentions are in use in the forum to tag people, e.g. @Tim.Leonard (sorry Tim 😆) However they are coming into use in the collaboration area of the reporting etc so that people can discuss via Phocas some result a query. ---
**Author:** ![Muecke](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/muecke/32/505_2.png) [@Muecke](https://pug.phocassoftware.com/u/Muecke)\ **Post date:** [August 8, 2019, 9:07am UTC](https://pug.phocassoftware.com/t/modus-anpassen-apply-refraction-to-new-column/1189/5 "2019-08-08T09:07:41Z")
My suggestion is not business-critical, it would only make the work much easier. Is there an overview of which functions are available when calculating? Exactly this function I wanted to produce with the @, in the forum a person is referred to, when calculating on an already known result. Collaboration area ?? what is that? Can you send me the link to the other suggestion Calculations as a function? ---
**Author:** ![StuartH](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/stuarth/32/394_2.png) [@StuartH](https://pug.phocassoftware.com/u/StuartH)\ **Post date:** [August 8, 2019, 10:18am UTC](https://pug.phocassoftware.com/t/modus-anpassen-apply-refraction-to-new-column/1189/6 "2019-08-08T10:18:53Z")
In any grid report the collaboration bit is the comments section. ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/4b5ba2d4147dce3d2bc49285c30ac45f8c77d8ac.png) At the moment it just a way of having a limited conversation with someone but the use of @mentions will enhance this to highlight a new comment to that person (like it does in the forum) ---
**Author:** ![JonKemp](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/jonkemp/32/334_2.png) [@JonKemp](https://pug.phocassoftware.com/u/JonKemp)\ **Post date:** [August 9, 2019, 12:39pm UTC](https://pug.phocassoftware.com/t/modus-anpassen-apply-refraction-to-new-column/1189/7 "2019-08-09T12:39:50Z")
Shorthand references in custom mode gets my vote, I can make some our nasty equations much easier to handle. Regards, Jon ---
**Author:** ![anon33838874](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@anon33838874](https://pug.phocassoftware.com/u/anon33838874)\ **Post date:** [August 11, 2019, 12:16am UTC](https://pug.phocassoftware.com/t/modus-anpassen-apply-refraction-to-new-column/1189/8 "2019-08-11T00:16:34Z")
Hi @Muecke, I agree with you that custom mode can be hard when dealing with the same calculated value multiple times. This suggestion has been logged. We currently have a full backlog of work so I can’t provide a timeframe for this to be completed. If you use these calculated values in different custom mode calculations often then I suggest you get them added as measures to the database to make it easier for you. ---
**Author:** ![Muecke](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/muecke/32/505_2.png) [@Muecke](https://pug.phocassoftware.com/u/Muecke)\ **Post date:** [September 16, 2019, 5:00pm UTC](https://pug.phocassoftware.com/t/modus-anpassen-apply-refraction-to-new-column/1189/9 "2019-09-16T17:00:31Z")
Sorry I haven’t been to work in a while. @StuartH Jetzt verstehe ich das @ Zeichen. habe ich bisher noch nicht verwendet. [EDIT] Now I understand the @ sign. I haven’t used it yet. [/EDIT] @anon33838874 That is very good that my suggestion has found recognition, and you have included it in the to-do list. How can I find out when you finished something like this? Newsletter? or is there a kind of ticket for it? or do you report it here in the entertainment? I am only a user in a large corporation, unfortunately I cannot determine what is included in our database. ---
**Author:** ![StuartH](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/stuarth/32/394_2.png) [@StuartH](https://pug.phocassoftware.com/u/StuartH)\ **Post date:** [September 16, 2019, 6:15pm UTC](https://pug.phocassoftware.com/t/modus-anpassen-apply-refraction-to-new-column/1189/10 "2019-09-16T18:15:03Z")
Thanks, love that Will’s response is in English but mine in German. 😆 Grateful for Google Translate 👍 ---
**Author:** ![Muecke](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/muecke/32/505_2.png) [@Muecke](https://pug.phocassoftware.com/u/Muecke)\ **Post date:** [September 16, 2019, 6:43pm UTC](https://pug.phocassoftware.com/t/modus-anpassen-apply-refraction-to-new-column/1189/11 "2019-09-16T18:43:12Z")
Sorry. I always write in german and translate that then by [deepl.com](http://deepl.com) sorry I forgot with your answer ☹ ---
**Author:** ![anon33838874](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@anon33838874](https://pug.phocassoftware.com/u/anon33838874)\ **Post date:** [September 17, 2019, 4:15am UTC](https://pug.phocassoftware.com/t/modus-anpassen-apply-refraction-to-new-column/1189/12 "2019-09-17T04:15:46Z")
@Muecke we release each month and you can find out what’s included by looking at the release notes on our documentation space. [https://helpphocassoftware.atlassian.net/wiki/spaces/userdoc/pages/52429217/Phocas+8.0.5+release+notes](https://helpphocassoftware.atlassian.net/wiki/spaces/userdoc/pages/52429217/Phocas+8.0.5+release+notes) ---
**Author:** ![Muecke](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/muecke/32/505_2.png) [@Muecke](https://pug.phocassoftware.com/u/Muecke)\ **Post date:** [September 17, 2019, 4:23pm UTC](https://pug.phocassoftware.com/t/modus-anpassen-apply-refraction-to-new-column/1189/13 "2019-09-17T16:23:10Z")
@anon33838874 Thanks for the info because I’ll look more often from now on. ---
**Author:** ![StuartH](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/stuarth/32/394_2.png) [@StuartH](https://pug.phocassoftware.com/u/StuartH)\ **Post date:** [September 18, 2019, 7:40am UTC](https://pug.phocassoftware.com/t/modus-anpassen-apply-refraction-to-new-column/1189/14 "2019-09-18T07:40:21Z")
You can also access it from the user icon in the top right of Phocas ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/7f5593fa698574b2308a97eaa701a8eb847cd0b4.png)