Known Issues

Release 2.3

On some Excel versions you might get error “We couldn’t refresh table ‘CurrencyConv” from connection ‘CurrencyConv’. Here is the error message we got: The ‘CurrencyFrom’ column does not exists in the rowset”. To fix this issue - please re-download External Data Management scripts - they now include code to create additional schema.ini file in external data folder. This file will let Excel know that column separator is TAB and not default comma.

Release 2.2

Here is the list of known issues/bugs reported by users:

  • Measure “Sales Cost Basis” in some conditions returns incorrect results. To fix this formula needs to be replaced with:
    =IF(NOT(HasOneValue(ReportCurrency[CurrencyID])), CALCULATE(SUM(Trans[CostBasisImpact]), TransType[SellFlag]=1) , SWITCH(VALUES(ReportCurrency[CurrencyID]), 1, CALCULATE(SUM(Trans[CostBasisImpactRpt1]), TransType[SellFlag]=1) , 2, CALCULATE(SUM(Trans[CostBasisImpactRpt2]), TransType[SellFlag]=1) , 3, CALCULATE(SUM(Trans[CostBasisImpactRpt3]), TransType[SellFlag]=1) , CALCULATE(SUM(Trans[CostBasisImpact]), TransType[SellFlag]=1) ) ) * (-1)
  • Measure “Sales Amnt” currently does not account for fee. It is also calculated for SymbolTransferOut transaction type. To change this formula needs to be changed to:
    =CALCULATE(SUMX(Trans, (ROUND([TotalAmnt] * Related(TransType[CashImpactSign]), 2)) * Report[TransReportExchRate]) , TransType[SellFlag]=1 )
  • Measure “Dividends %” might not be calculated properly in certain conditions. To fix this formula needs to be change.
    Formula for Excel 2010 / 2013:
    = IF(CALCULATE(VALUES(Config[GenDivUsed]), All(Config))=“Y” , EXP( SUMX(VALUES(Dates[Month]) , LN(1+DIVIDE( CALCULATE(SUMX(Trans, Trans[TotalAmnt] * Report[TransReportExchRate]), TransType[DividendFlag]=1) + CALCULATE(SUMX(Trans, Trans[AccruedInterest] * (-1) * Related(TransType[BookValueSign]) * Report[TransReportExchRate]), TransType[BookValueSign] <> 0) + IF(COUNTROWS(CALCULATETABLE(Dividends))>0, Report[Gen Div Amnt]) , Report[Total Value] ) ) ) ) - 1 , EXP( SUMX(CALCULATETABLE(VALUES(Dates[Month]), Trans, TransType[DividendFlag]=1) , LN(1+DIVIDE( CALCULATE(SUMX(Trans, Trans[TotalAmnt] * Report[TransReportExchRate]), TransType[DividendFlag]=1) + CALCULATE(SUMX(Trans, Trans[AccruedInterest] * (-1) * Related(TransType[BookValueSign]) * Report[TransReportExchRate]), TransType[BookValueSign] <> 0) , Report[Total Value] ) ) ) ) - 1 )

    Formula for Excel 2016/Power BI:

    =IF(CALCULATE(VALUES(Config[GenDivUsed]), All(Config))=“Y” , PRODUCTX(VALUES(Dates[Month]) , 1+DIVIDE(CALCULATE(SUMX(Trans, Trans[TotalAmnt] * Report[TransReportExchRate]), TransType[DividendFlag]=1) + CALCULATE(SUMX(Trans, Trans[AccruedInterest] * (-1) * Related(TransType[BookValueSign]) * Report[TransReportExchRate]), TransType[BookValueSign] <> 0) + IF(COUNTROWS(CALCULATETABLE(Dividends))>0, Report[Gen Div Amnt]) , Report[Total Value] ) ) - 1 , PRODUCTX(CALCULATETABLE(VALUES(Dates[Month]), Trans, TransType[DividendFlag]=1) , 1+DIVIDE(CALCULATE(SUMX(Trans, Trans[TotalAmnt] * Report[TransReportExchRate]), TransType[DividendFlag]=1) + CALCULATE(SUMX(Trans, Trans[AccruedInterest] * (-1) * Related(TransType[BookValueSign]) * Report[TransReportExchRate]), TransType[BookValueSign] <> 0) , Report[Total Value] ) ) - 1 )