Problem: DrillDown option missing from some functions
Product: BizInsight
Applies to: MAS 500
Article Type: Problem
Summary:
A user right-clicks on a cell containing a BizInsight function, chooses the BizExcelerator option but does not see the DrillDown option and have the ability to select it. The drilldown option is available for other functions in their worksheet.
Details:
The function for which the drilldown option is missing is for an account with a credit amount and the sign of the data has been changed. The user has preceded the BizInsight function with a “-“ to change the sign.
This issue will occur if anything is put between the BizInsight function and the equal sign “=” that starts the function.
Resolution/Workaround:
To resolve this issue, remove all characters that are between the equal sign “=” and the BizInsight function.
If you want to change the sign of the data retrieved by the function, add “*-1” to the end of the function to change the sign.
If the provided Resolution/Workaround does not resolve your issues, please contact BizNet Software Support for further assistance.