2 Replies Latest reply on Jan 10, 2019 9:14 AM by Vikram Gokhale

    Operations in unequal rows

    Miguel Duran

      Hi,

       

      Here is an interesting problem (which I don't manage myself to sort out). This is my situation:

      Screenshot 2019-01-10_17-07-52-178.png

      Some Languages contain two rows for Sales A and Sales B, and in this case, I would like to calculate [Sales B] - [Sales A] in the [MOS_delta] calculated field. Problem is that the order of the Sales A and the Sales B rows is not always the same, so something like

       

      [Sales B]-LOOKUP([Sales A],1)

      or

      [Sales B]-LOOKUP([Sales A],-1)

       

      will not always work. I have also try to ZN (fill void cells with zeros) but I don't get any further

       

      Cases where there is only one row per Language should be ignored (null in MOS_delta).

       

      Can anybody help me out?

       

      Thanks,

      Miguel