Key Performance Indicator (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.
TopalBaeKpiValueBySubnodeNameAndDates("SubnodeName";"Name";"Datefrom"; Dateuntil")
|
This Function returns the Key Performance Indicators (KPI) Value based on the SubnodeName, Name and Daterange
Function call:
=TopalBaeKpiValueBySubnodeNameAndDates("Geldflussrechnung";"Unternehmenserfolg";"01.01.2014";"31.03.2014") or =TopalBaeKpiValueBySubnodeNameAndDates("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.
TopalBaeKpiValueBySubnodeNameAndClientDates("Client";"SubnodeName";"Name";"Datefrom"; Dateuntil")
|
This Function returns the Key Performance Indicators (KPI) Value based on the Client, SubnodeName, Name and Daterange
Function call:
=TopalBaeKpiValueBySubnodeNameAndClientDates("Mon Bijou AG";"Geldflussrechnung";"Unternehmenserfolg";"01.01.2014";"31.03.2014") or =TopalBaeKpiValueBySubnodeNameAndClientDates("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.
