Hello,
I am currently having a problem with the sum function. My revenue for a particular quarter should be for ex: 300M, instead it is around 200B. My expression for this is
sum({<[# of FQs from current FQ]={0,'-1','-4'}>}[TOTAL REVENUE ($)])
I also have graphs summing the total # of billed sales, and they are double or quadruple counting as well, so it must be a problem with my load script? Same formula i just replaced [TOTAL REVENUE ($)] with [TOTAL BILLED SALES]
Furthermore, I have a simple chart that was able to correctly calculate the revenue for each quarter a few days ago, and now is summing just like my charts.
At the same time, from a completely different load file and script I am summing my revenue by product sold, and further my revenue should be summed across 8 quarters with each quarter summing to a different amount, in the form of a pivot table. Instead three of the quarters will have the exact same revenue down to the dollar, then the next 5 will all have the same revenue. My expression is as follows;
sum({$<[# of FQs from current FQ]={0,'-1','-2','-3','-4','-5','-6','-7','-8','-9','-10'}>}[TOTAL REVENUE ($RL)])
I realize that my fields are very similar, but they are different, notice the RL, and the excel file that each one loads from has them correctly labeled.
Thanks so much for all your help,
Alex
