5 Replies Latest reply: Sep 25, 2018 2:35 PM by Shahbaz Khan Mohammed

# Report Current Quarter Values

Hi,

I have a dial that currently reports current month. How do I amend my logic to report current quarter values please?

I have tried the logic below but doesn't seem to provide any values when I know it should.

Sum({<DATE_IN = {">=\$(=Date(QuarterStart(Max(DATE_IN), -1)))<=\$(=Date(Max(DATE_IN)))"},

Team_Name = {'MenF'},Contract_Type ={'Upl'},

[Country] = {'UK'}>} Total_Contract_Val_new)

• ###### Re: Report Current Quarter Values

Current Quarter: =Year(Today())&'Q'&ceil(Month(Today())/3)

• ###### Re: Report Current Quarter Values

I have tried that but still get 0 value. May I have the wrong logic?

Sum({<DATE_IN =Year(Today())&'Q'&ceil(Month(Today())/3)},

Team_Name = {'MenF'},Contract_Type ={'Upl'},

[Country] = {'UK'}>} Total_Contract_Val_new)

• ###### Re: Report Current Quarter Values

Could you please share the .qvf?

• ###### Re: Report Current Quarter Values

Easier would be create a new field in back end

if(InQuarterToDate(DATE_IN, today(),0), 1, 0) as CurQtrFlag,

In front end

Sum({<CurQtrFlag={1},

Team_Name = {'MenF'},Contract_Type ={'Upl'},

[Country] = {'UK'}>} Total_Contract_Val_new)

• ###### Re: Report Current Quarter Values

Can you try below approach.... Right click on Total_Contract_Val_new in field list