Skip to main content
K
Kit_Tyrrell
Newcomer
July 5, 2023

IF logic in Cube View GetDataCell

  • July 5, 2023
  • 2 replies
  • 0 views

Hello,

I am trying to find a way to have my variance % follow my dollar variance value.   If a favorable variance, then the % variance should also be a positive percentage.  In this example I'm looking at variance in an absorption account.  Any thoughts on how this could be done?  

 

Kit_Tyrrell_0-1688590213699.png

 

      2 replies

      MikeG
      MikeG
      Contributor
      July 6, 2023

      Hi Kit_Tyrrell , have you tried using VariancePercent function in your column definition?  You can reference the other columns using CVC references.

      MikeG_0-1688641649178.png

       

      In your use case, BWPercent may work better, that one takes in to consideration the Account Types  Here's an example of that one from the Help doc.

      MikeG_1-1688641770297.png

      hope this helps.

        K
        Kit_TyrrellAuthor
        Newcomer
        July 7, 2023

        Thank you very much for the suggestions.   The BWPercent worked for what I needed.

          MikeG
          MikeG
          Contributor
          July 8, 2023

          Great!  Glad that worked for you Kit_Tyrrell .

          Terms & ConditionsAccessibility statement