Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello There,
I am facing problem when i am writing a condition with if statement which is not giving me the right values .
The Syntax is given below:
sum(if(vReportDate=[Posting Date] and (Season <>vCurrentSeason or (Season='NA' and Department='COR')),Quantity*-1))
I have to make a if statement in which posting date is the date which is entered by the user and season of a particular item is not equal to current season and also when season is NA and department is COR, it should NOT be included and rest all the season and department be included.
Kindly Help. I am Stuck !
sum(
if ( ($(vReportDate)=[Posting Date] and Season <>$(vCurrentSeason))
or
(Season='NA' and Department='COR')
,
Quantity*-1
)
)