Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Rajveer
Contributor II
Contributor II

Not able to understand this logic.

=Sum({$<PAID={1,2},FISCAL_MONTH=,FISCAL_YEAR=,QTR_NAME=,
PARENT_FISCAL_MONTH={">=$(=date(addmonths(max({<PAID={1,2}>}Date#(PARENT_FISCAL_MONTH,'YYYYMM')),-12),'YYYYMM'))
<=$(=date(max({<PAID={1,2}>}Date#(PARENT_FISCAL_MONTH,'YYYYMM')),'YYYYMM'))"} >}DISCOUNT_TAKEN_USD_AMOUNT)

Labels (1)
2 Replies
vincent_ardiet_
Specialist
Specialist

This is computing the sum of DISCOUNT_TAKEN_USD_AMOUNT in the following context:
 - PAID values are 1 and 2
 - Selections on FISCAL_MONTH, FISCAL_YEAR and QTR_NAME are not took in account
 - PARENT_FISCAL_MONTH is greater or equal to 12 months before the max PARENT_FISCAL_MONTH (for value with PAID = 1 and 2)
 - PARENT_FISCAL_MONTH is lower or equal to the max PARENT_FISCAL_MONTH (for value with PAID = 1 and 2)

 

Rajveer
Contributor II
Contributor II
Author

Thank you @vincent_ardiet_