Set Analysis in combination with Filter that has if condition - Not working

[Deepashree]

In a sheet I have a filter on Balance Date as seen below:

=if([Balance Date]<>'$(Min_BlcDate)',[Balance Date])  

Also I have column that uses Balance date in set analysis as follows:

Sum({<[Balance Date] = {'$(VPreviousBalanceDate)'}>}Value)

The issue is that due to condition on the filter, the column is returning zero but once i remove the condition, the output is correct. Could you please help me resolve this issue. 

Thanks in Advance!

[sbaro_bd]

Hi @Deepashree ,

I don't understand your issue. Can you add some screens to explain?

Regards.