›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Total allocation issue

jwengajwenga
in Excel Workbook

Hi Vidas, Im finally getting around to migrating to V3. Keep getting this error message. Thoughts? Thanks Joe

Comments

  • jwengajwenga
    Sorry here is the error message:

    MdxScript(model) (6, 162) Calc error in measure "report[Total Value by Allocation]: A table of multiple values was supplied where a single value was expected.
  • VidasMatelisVidasMatelis
    edited December 2023
    Can you please post how does your allocation table looks like.
    I am expecting it to be similar to this:



    I believe that issue should be somwhere between columns:
    Allocation[Allocation]
    Symbol[Allocation]
    SymbolAllocation[Allocation]
    Please make sure that in all 3 columns you are using the same values.
  • jwengajwenga
    Fixed now, thanks!
Sign In or Register to comment.