Expression

[upaliwije]

Dear Friends

I have following set expression which does not return a value

sum({<VFROM={">=$(v1)"}>}PREMIUM)

VFROM=DEC-2017 (  a field created  while loading data)  Month(POL_PERIOD_FROM)&'-'&Year(POL_PERIOD_FROM)AS VFROM

v1=      =DEC-2017 a vraiable (Let v1=Date(Makedate(2017,12,01),'MMM-YYYY'))

[upaliwije]

Sorry.  I seek your help to get my expression corrected

[michael_holzing]

Hi,

I think your field VFROM isn't a Date format. You have to turn your Dimension VFROM to a Date Format work with the operator ">=".
In your script, try the makedate function like this: MakeDate(Year(POL_PERIOD_FROM),Month(POL_PERIOD_FROM),'01') as VFROM

Cheers