Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
engr_farhanqadr
Creator
Creator

Multi selections in set analysis

Hi folks,

I am using the below formula , it is working fine when  I select Year and then one value for Quarter. like q1 or q2

but I want to multi select in quarter field for 6 months or 9 months what to change in below formula.  

sum({<Year=,Quarter=,YearlyQuarter=,
[settle_master.Year]=,[settle_master.Month]=,
[Master_INTIMATION.Year]=,[Master_INTIMATION.Quarter]=,[Master_INTIMATION.Month]=
,[Master_INTIMATION.YearlyQuarter]={"<$(=GetFieldSelections(YearlyQuarter))"}
,[settle_master.Year]={">=$(=GetFieldSelections(Year))"}, [settle_master.YearlyQuarter]={">=$(=GetFieldSelections(YearlyQuarter))"} >} PAID)
+
sum({<Claim_settle_date={'N/A'},[Master_INTIMATION.Year]={"<=$(=GetFieldSelections(Year))"},
[Master_INTIMATION.YearlyQuarter]={"<$(=GetFieldSelections(YearlyQuarter))"},
Year=,Quarter=,YearlyQuarter=,
[settle_master.Year]=,[settle_master.Month]=,
[Master_INTIMATION.Quarter]=,[Master_INTIMATION.Month]=>} PAID)

Thanks.

 

Labels (2)
0 Replies