3 Replies Latest reply: Apr 13, 2016 10:26 AM by Joaqu�n L�zaro RSS

    Financial Period calculations

    Andre Toerien

      Hi

       

      I have a table which I am importing with data linked to Financial period

      Example

      Account    LastReconPeriod  ReconType

      1              201511                  Full

      2              201511                  Part

       

      The Current Financial Period is say 201601

       

      If Recon Type is Full the ReconPeriod remains the LastReconPeriod

      If Recon Type is Part the ReconPeriod is the LastReconPeriod -1 20 it is 201510


      I need to give them a column with colour Green in the LastReconPeriod is the Current Period - 1, Orange if it is CurrentPeriod - 2, red if its CurrentPeriod -3 or more so for Account 1 the column is Orange, but Account 2 it would be red as the actual value is 201510 as it is only Partly Reconned


      Any suggestions