Forum Discussion
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...
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
Hi,
OK. I get it now. Please share the link from where i can download your file.
do you need the file?
How can i share the file?
Upload it to OneDrive/Google Drive or an other such service and share the download link.
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