1 Reply Latest reply on Oct 30, 2018 11:29 AM by Mavis Liu

    How to calculate the difference of two values?

    Felipe Caon

      Hello all, I vanished the forums looking for the answer for this, but could find one that could satisfy my requirements.

       

      What I want to do: I need to make a calculated field where it will be populated with the difference of [Actual] based on yearmon

       

      Example: For 201809, it should be [Actual] of metric label, 201809 - [Actual] of metric label, 201809, by type

                      For 201807, it should be [Actual] of metric label, 201807 - [Actual] of metric label, 201806

       

       

      How can I do it?

       

      So..

       

      If i want the difference of Volume/NARDT for 201909, it should be -63609 - (null), because 201808 is non existent

                                              Volume/NARDT for 201907, it should be 3647 - (305) blue box - red box in image 1

       

       

      Any help?