none
CubeValue formula returns #N/A when linked to a data validation list RRS feed

  • Question

  • Hello,

    I've built a report using CubeValue formulas for comparing Monthly Target to Month Actual and the formula references cells for the Financial Year value and the name of the clinic.  When I change the cell referencing the Clinic Name to a cell with a Data validation List, the formula keeps working fine.  However, then I change the cell referencing the Financial year to a cell with a Data Validation List, the formula returns a #N/A.

    This is my Cubevalue formula =CUBEVALUE("ThisWorkbookDataModel","[Measures].[No MBS Items]","[Table_MBS].[KPI].&["&$AB8&"]]","[Calendar].[Period].&["&AC$5&"]","[Calendar].[FinYear].&["&$Z$35&"]","[Place].[Place].&["&$Z$37&"]")

    Cell Z35 is the reference cell for Financial Year and Z37 is the cell that references the Clinic Name

    Does anyone have any idea why changing the cell from Financial year to a data validated cell creates the error?

    Thursday, November 29, 2018 2:17 AM

All replies