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

Highlighted
Previous Contributor

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

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

1 REPLY 1
Highlighted
Previous Contributor

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

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.