Problem with Nofilter()

building reports desktopintelligence
1

I have a table with Month and Revenue. I have a applied on month to show the latest 3 months data. Also, I have a column Revenue YTD (Nofilter(RunningSum()) . It’s not working. Is there anything wrong with the formula I am using ? It just shows the runningsum of the rows displayed.

Thanks,
Prathima

nandita (BOB member since 2004-06-22)

2

If you take the filter off that table, is the runningsum now correct?

3

There is nothing wrong with the formula.
I tried it here and it works as expected.
Are there any other formatting , restrictions you have applied on the block?
I know this is remote possibility but, By any chance is there a possibility that you are fetching only 3 months of data in report :rotf:

mkumar (BOB member since 2002-08-26)

4

Thanks for your replies…
I absolutely do not understand what was the problem… But I got it working by changing the formula to ,
=NoFilter(RunningSum()) Where ( = “Q1”) + NoFilter(RunningSum()) Where ( = “Q2”) + NoFilter(RunningSum()) Where ( = “Q3”) + NoFilter(RunningSum()) Where ( = “Q4”)

Thanks

nandita (BOB member since 2004-06-22)