5 Replies Latest reply on Mar 21, 2018 4:22 AM by Yuriy Fal

    Aggregation problem

    Silvia Assuncao

      Hi,

      I have this calculated field that works okay when I have as Company Name as Dimension.

      But then, when I duplicate it and include Category Dimension, the total value for IF VARIATION gets a little messed up.

      when I duplicated it again and excluded the Company Name so that I would have the consolidation by Category only, this IF VARION is even more messed up.

      could anyone help me solving calculated field so that when I want to have the values by Category the IF VARIATION is the same as considering the Company Name aggregation.

      FIELD.PNGconsolidataion_snap.PNG