1. if(Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}, _History = {1}>} Sales/$(vCurrency)) > Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}, _History = {1}>} Budget_$(vCurrency)), 1, -1)

Report Inappropriate Content · ‎2014-02-17

Hi,

I new to QV, Can Anybody help me to understand this expressions please...

1. if(Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}, _History = {1}>} Sales/$(vCurrency)) > Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}, _History = {1}>} Budget_$(vCurrency)), 1, -1)

2. if(Space <> 's', Sum ({<Year = {$(=Max(Year)-1)}, Month = {'<= $(=num(Month(vTodaysDate)))'}>}Actual * PL_Flag) + Sum({<Year = {$(=Max(Year)-1)}, Month = {$(=Month(vTodaysDate))}>}[Closing Amount] * BS_Flag),

thanks in advcance

Regards

Venu Gopal

jagan · ‎2014-02-17

Hi Venu,

1:

If Sales for Current and Previous years are > Budget for Current and Previous years then 1, else -1 is returned.

2:

If Space is not equal to 's',

then sum of Actual * PL_Flag for previous year till this month + sum of Closing Amount * BS_Flag of previous year current month.

Hope this helps you.

Regards,

Jagan.

Imp Expression

Hi,

1. if(Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}, _History = {1}>} Sales/$(vCurrency)) > Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}, _History = {1}>} Budget_$(vCurrency)), 1, -1)