Dynamic Calc Rule
Hi All
In the below example value is displayed on every single combination of UDs. This should only be calculated and written to each UD7 separately but calculated on Tops and displayed only o...
Forum Discussion
Hi, you need to define the other UD members that this data may be displayed on. You cannot say for all other UD members display no data. In your case this means that you can say only display data if the POV of my cube view is on "Top" for each UD member other than UD7 (E.g. by adding an if statement such as If Api.Pov.UD1.Name = "Top" etc. Else Return Nothing). Keep in mind that the cube view POV needs to be set accordingly for this dynamic account to display data - the users need to be educated accordingly.
On another note, your "dEbit/dSalesProd" will error our when dSalesProd is zero. When you use the Divide function, this will not happen (from Snippets "DynamicCalcDivide"):
Return api.Data.GetDataCell("Divide(A#ACCOUNT1,A#ACCOUNT2)")