Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I have the following formula:
=
sum( {1<Boekingsdatum = {">39941<40178"}>} [Prorata inkomsten] )
how can i change the 39941 with a calculated number; for example max(Date)?
Regards
Timmy
You can use formulas in your set expressions using dollar-sign expansion. The following example is from the QV documentation:
sum( {$<Year = {$(#=Only(Year)-1)}>} Sales )