Results 1 to 3 of 3

Thread: calculate percent of the amount in the row before

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Aug 2009
    Location
    Germany
    Posts
    54

    Default calculate percent of the amount in the row before

    Hello,

    is there a pre-build function to show the percent of a amount as a basis of the amount above?

    I want to show the difference in percent of the turnover in the timeline.

    Thanks
    Carsten


    ----------------------------------------------------------------------------------------------------
    Hier vielleicht noch in deutsch, da ich nicht weiß, ob ich das in Englisch gut beschrieben habe:

    Gibt es eine vorgefertigte Funktion, um den Prozentsatz eines Wertes in Bezug auf den Wert in der Zeile darüber darzustellen? Also die prozentuale Veränderung des Umsatzes zum Vorjahr.

  2. #2
    Join Date
    Feb 2009
    Posts
    1,496

    Default Re: calculate percent of the amount in the row before

    Hi Carsten,

    In design on the list options tab page, in the Calculated Totals section there are "running column" options, two of which are percentages. Maybe one of those options in combination with a total formula would work.

    Another option that might work would be to make a comparison type report. This is done by choosing among the various compare options available in the "search type" drop down in the Filters section on the list options tab in design. Then all totals in the report are compared according to the compare filter values provided at run-time.

    Also you can reference an explicit group total in a key figure and then you can also reference that key figure in a formula in the report -- so maybe that would be a solution. The syntax for referencing an explicit group total is [[Total_Name]]::Grouped_Column_Name==Group_Value]] and here is what that looks like:
    Click image for larger version. 

Name:	KeyFigureFormulaExamples.png 
Views:	92 
Size:	103.0 KB 
ID:	6938

    If none of these work in your circumstance, then you will have to write some clever SQL to create an additional column to the result set -- or -- maybe rethink the approach to the problem and take advantage of how the final drill-down object in any Dynamic AI report can be to another report. It would be helpful to see an explicit example of the result you are trying to achieve.

    Regards,
    Bob

  3. #3
    Join Date
    Feb 2009
    Posts
    1,496

    Default Re: calculate percent of the amount in the row before

    BTW, I usually just use the on-screen formula editor and click on the totals I want to reference. The editor creates the correct syntax and avoids making a syntax or spelling error.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •