KPI

Gets the Key Performance Indicator of Item.

TopalBaeKpiValueByDates("Name";"Datefrom"; Dateuntil")

This Function returns the Key Performance Indicators (KPI) Value based on the Name and Daterange.

Function call:
=TopalBaeKpiValueByDates("Unternehmenserfolg;"01.01.2014";"31.03.2014") or =TopalBaeKpiValueByDates("Name";"DateFrom";"DateUntil")

Example:

Figure 1: parameter

Figure 2: return formula value

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeKpiValueByClientDates("Client";"Name";"Datefrom"; Dateuntil")

This Function returns the Key Performance Indicators (KPI) Value based on the Client, Name and Daterange.

Function call:
=TopalBaeKpiValueByDates("Mon Bijou AG";"Unternehmenserfolg;"01.01.2014";"31.03.2014") or =TopalBaeKpiValueByDates("Client";"Name";"DateFrom";"Dateuntil")

Example:

Figure 3: parameter

Figure 4: return formula value

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeKpiValueByTreeNameAndDates("SubnodeName";"Name";"Datefrom"; Dateuntil") [WORKING PROCESS]

This Function returns the Key Performance Indicators (KPI) Value based on the SubnodeName, Name and Daterange

Function call:
=TopalBaeKpiValueByTreeNameAndDates("Geldflussrechnung";"Unternehmenserfolg";"01.01.2014";"31.03.2014") or =TopalBaeKpiValueByTreeNameAndDates("SubnodeName";"Name";"01.01.2014";"31.03.2014")

Example:

Figure 5: parameter

Figure 6: return formula value

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.

TopalBaeKpiValueByTreeNameAndClientDates("Client";"SubnodeName";"Name";"Datefrom"; Dateuntil")

This Function returns the Key Performance Indicators (KPI) Value based on the Client, SubnodeName, Name and Daterange

Function call:
=TopalBaeKpiValueByTreeNameAndClientDates("Mon Bijou AG";"Geldflussrechnung";"Unternehmenserfolg";"01.01.2014";"31.03.2014") or =TopalBaeKpiValueByTreeNameAndClientDates("Client";"SubnodeName";"Name";"01.01.2014";"31.03.2014")

Example:

Figure 7: parameter

Figure 8: return formula value

Error Message:
An error will be displayed if given account does not exist in your Chart of Account.