How do I have a forumla calculate data to a specific dimension member?

PrevContributor
PrevContributor
in Modeling

How can I have a formula calculate data for a specific member of a dimension and place a 0 for the others?

Tagged:

Best Answer

  • PrevContributor
    PrevContributor
    Answer ✓
    You can do this with a conditional: If ITEM(List) = List.item then ... else 0
    Where the List is a dimension in the module.  This type of formula can also be used on a source module that has a list formatted line item and the target module has that list as a dimension.

Categories