Set analysis R12

[#1]

hi i have some issues with my R12 calculation could someone take a look and help please.

=Count({$<[Datum]={"<=$(=DATE(Today()),'YYYYMMDD') >= $(=DATE(Today()-365),'YYYYMMDD')"}>}
DISTINCT TP_ID)

[sunny_talwar · Accepted solution]

Try reversing the order and no space between )>=$(

=Count({$<[Datum]={">=$(=DATE(Today()-365),'YYYYMMDD')<=$(=DATE(Today()),'YYYYMMDD')"}>} DISTINCT TP_ID)

Update: Fixing issues in the expressions pointed out by Max

=Count({$<[Datum]={">=$(=DATE(Today()-365,'YYYYMMDD')<=$(=DATE(Today(),'YYYYMMDD')"}>} DISTINCT TP_ID)

[Clever_Anjos]

Is your  field Datum formated YYYYMMDD?

[Anonymous]

Try with bypassing the date field like?

=Count({<[Datum]=, [Datum]={'>=$(=DATE(Today()-365),'YYYYMMDD')<=$(=DATE(Today()),'YYYYMMDD')'}>} DISTINCT TP_ID)

=Count({<[Datum]=, [Datum]={'>=$(=DATE(Today()-365,'YYYYMMDD'))<=$(=DATE(Today(),'YYYYMMDD'))'}>} DISTINCT TP_ID)

Note:  Make sure format of Datum should be 'YYYYMMDD'

[PrashantSangle]

Hi,

There is closing bracket error for date()

Check and modify other wise there is no issue in your expression

It is supposed to below

Date(Today(),'YYYYMMDD')

where you did

Date(Today()),'YYYYMMDD')

same for other date(Today()-365,'YYYYMMDD')

Regards

[sunny_talwar]

Good catch max.

[PrashantSangle]

Thanks..