Skip to main content

I would like your help with the following:

* 3 calculated columns in one table.

* Total Xmas sales last year, Xmas sales up to this week last year, and Xmas sales this year

*Combining all the columns, I get a wrong last year total.

 

If I comment out this week last year, I get a correct last year total.. I think the problem is with my calculated field logic

 

IF  (DATEPART('year',[Enquiry Created]) = 2016 AND DATEPART('week',[Enquiry Created]) <= DATEPART('week',today(), 'sunday')+1) THEN '2016 Now'

ELSEIF  DATEPART('year',[Enquiry Created]) = 2017 AND [Event Date] >= ⌗November 1, 2017# AND [Event Date] <= #January 31, 2018# THEN '2017 Now'

ELSEIF  [Event Date] >= #October 1, 2016# AND [Event Date] <= #January 31, 2017# THEN '2016 Total'

ELSE 'NULL'

END

 

Help with Calculated Field Logic

Thanks for your help

3 Antworten
  1. 21. Aug. 2017, 14:01

    Hi, Allen

     

    Is this the result you expected?

    Hi, Allen Is this the result you expected? If yes, please see the below calculation fields I created for achieving this. Hope this could help.

     

    If yes, please see the below calculation fields I created for achieving this.

    pastedImage_1.png

     

    Hope this could help.

     

    ZZ

0/9000