how to write a set analysis

[kunkumnaveen]

Hello ,

           how to write this in set analysis  DOC_DATE>VALIDFROM  and  <VALIDTO

i tried this

                        DOC_DATE={">=$(VALIDFROM )<=$(VALIDTO)"}

Only the DOC_DATE=01-07-2017 is a valid one,i need to show only that   AMOUNT

Any suggestion plz

[sunny_talwar]

Better to use if statement here or create a flag in the script

If(DOC_DATE > PK_VALIDFROM and DOC_DATE < PK_VALIDTO, 1, 0) as Flag

[kunkumnaveen]

Hello ,thanks for your reply ,

At script level DOC_DATE is coming from different table

and the rest two Fields are coming from different table

i think i need to create to it in set analysis only?

if so

sum(DOC_DATE={">=$(VALIDFROM )<=$(VALIDTO)"}>}Amount)

[sunny_talwar]

Then I would say, just use this:

Sum(If(DOC_DATE > PK_VALIDFROM and DOC_DATE < PK_VALIDTO, AMOUNT))