Forum Discussion

jbjs5820's avatar
jbjs5820
Icon for Helper I rankHelper I
8 years ago
Solved

Rolling = Real + BGT

Hello,  I´m trying to calculate only a a Real + Budget.   The formula is = If( [Real]<>Blank();[REal];[BGT]   It gives me month to month what i want.   The Problem is in the End ( The sum is W...
Need Help
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    I removed the data field from the row labels and dragged Year and Month Name field from the DATA Table.  I modified the Rolling PDV formula to

     

    =if(HASONEVALUE(DATA[MonthName]),if([Real n Pdv]=Blank(),[BGT(JL)],[Real n Pdv]),SUMX(SUMMARIZE(DATA,[MonthName],"ABCD",if([Real n Pdv]=Blank(),[BGT(JL)],[Real n Pdv])),[ABCD]))

    Here's a screenshot

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Upload it to OneDrive/Google Drive or an other such service and share the download link.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    I removed the data field from the row labels and dragged Year and Month Name field from the DATA Table.  I modified the Rolling PDV formula to

     

    =if(HASONEVALUE(DATA[MonthName]),if([Real n Pdv]=Blank(),[BGT(JL)],[Real n Pdv]),SUMX(SUMMARIZE(DATA,[MonthName],"ABCD",if([Real n Pdv]=Blank(),[BGT(JL)],[Real n Pdv])),[ABCD]))

    Here's a screenshot

     

    • jbjs5820's avatar
      jbjs5820
      Icon for Helper I rankHelper I
      8 years ago

      Thanks a lot!

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        8 years ago

        You are welcome.