Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I new to QV, Can Anybody help me to understand this expressions please...
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
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.