Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
akuligod
Contributor
Contributor

Sum logic

The formula below does not seem to work. Kindly suggest corrections.

  • trying to sum campaign data from campaign date to 3 months later.
  • checked all date formatting.

Count({$<DataType={'Registration'},

          RegItemStatus={'Approved','Expired'},

          RegItemReviewDate_YYYYMM={">$(=CampainDate_YYYYMM)<$(=CampainDateAfter_YYYYMM)"}

          >} DISTINCT Design_Parts)

stalwar1

4 Replies
vishsaggi
Champion III
Champion III

Did you try like

Sum(Aggr(Count({$<DataType={'Registration'},

          RegItemStatus={'Approved','Expired'},

          RegItemReviewDate_YYYYMM={">=$(=CampainDate_YYYYMM)<$(=CampainDateAfter_YYYYMM)"}

          >} DISTINCT Design_Parts), Dimension1, Dimension2))

akuligod
Contributor
Contributor
Author

Sir,

This is not working.

Dim 1, Dim2 not recognized.

sunny_talwar

Is this similar to this thread? Sum within a date range

akuligod
Contributor
Contributor
Author

Yes Sir.