max date for current quarter

[#1]

Hi ,

How do we use <=max(date) for current quarter in set expression.

below max(REQ_DATE) return 12/31/2015 but i want to compare with current quarter max date i.e 6/30/2015.

Sum({$< Type = {'O'}, C_TYPE = {'Y'}, Year = {$(#vFYear)}, Quarter = {$(#vFQuarter)} ,REQ_Year = {$(#vFYear)}, REQ_DATE = {"<=$(=max(REQ_DATE))"}>} USD_NET_VALUE) / 1000

Thanks

Rajesh G

[sunny_talwar]

Maybe something like this:

Sum({$< Type = {'O'}, C_TYPE = {'Y'}, Year = {$(#vFYear)}, Quarter = {$(#vFQuarter)} ,REQ_Year = {$(#vFYear)}, REQ_DATE = {"<=$(=max(<{Quarter = {$(#vFQuarter)}>}REQ_DATE))"}>} USD_NET_VALUE) / 1000

Best,

Sunny

[sunny_talwar]

My guess is that #vFQuarter is related to current quarter? right?

[#4]

Yes correct #vFQuarter  related to current quarter,let me check your expression

[#5]

no its not return correct value,looks some thing wrong

[sunny_talwar]

What do you see when you put this in a text box: =max(<{Quarter = {$(#vFQuarter)}>}REQ_DATE)? Do you see 06/30/2015

[sunny_talwar]

Also you might have to use Date() to make sure that max doesn't spits out a number result instead of a date

Sum({$< Type = {'O'}, C_TYPE = {'Y'}, Year = {$(#vFYear)}, Quarter = {$(#vFQuarter)} ,REQ_Year = {$(#vFYear)}, REQ_DATE = {"<=$(=Date(max(<{Quarter = {$(#vFQuarter)}>}REQ_DATE), 'yourDateFormat'))"}>} USD_NET_VALUE) / 1000

[Anonymous]

Hi,

you can directly use QuarterEnd(today()) for current quarter max date it will return 30-06-15

you dont need to have multiple filters for year and all.

Thanks

BKC