Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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)
Then I would say, just use this:
Sum(If(DOC_DATE > PK_VALIDFROM and DOC_DATE < PK_VALIDTO, AMOUNT))