topic Expression in App Development

Expression

upaliwije — Fri, 14 Dec 2018 07:16:56 GMT

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'))

Re: Expression

upaliwije — Fri, 14 Dec 2018 07:18:19 GMT

Sorry. I seek your help to get my expression corrected

Re: Expression

michael_holzing — Fri, 14 Dec 2018 07:57:32 GMT

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