Sum logic

[akuligod]

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‌

[vishsaggi]

Did you try like

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

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

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

          >} DISTINCT Design_Parts), Dimension1, Dimension2))

[akuligod]

Sir,

This is not working.

Dim 1, Dim2 not recognized.

[sunny_talwar]

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

[akuligod]

Yes Sir.