Set Analysis

[#1]

The year start is 03/04/2014 and 01/04/2013.

Data is available for the said dates but getting the opening stock as 0.

=Sum({$<DATE={$(date(min({<FinYear={$(=Max(FinYear))}>} DATE)))}>}OpeningStock)

[#2]

Hi Uday,

could you please share the sample application QVW for better understanding.

-- Rajendra

[tresesco · Accepted solution]

If I see only at the expression, it has to be corrected like:

=Sum({$<DATE={"$(=date(min({<FinYear={"$(=Max(FinYear))"}>} DATE)))"}>}OpeningStock)

[#4]

Thanks Tresesco. Its working .