Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
HhAaRrIi
Contributor
Contributor

How to caluclate Reverse Caluclation

Hi All,

 

Can Any one please help me ,

RangeSum(Below(Total Sum(Aggr(If(($(vMTD_Actual_CVR))>=5,($(vMTD_Domestic)*5)+($(vMTD_International)*10),
(($(vMTD_Booking%))*($(vMTD_Domain%))*5)+(($(vMTD_Booking%)*(1-($(vMTD_Domain%)))*10))),-0,Rowno(Total)))))

/*Rangesum(Below(Total Sum(Aggr(If(($(vMTD_Actual_CVR))>=5,($(vMTD_Domestic)*5)+($(vMTD_International)*10)
,(($(vMTD_Booking%))*($(vMTD_Domain%))*5)+(($(vMTD_Booking%)*(1-($(vMTD_Domain%)))*10)))),-0,Rowno(Total))))

This is my expression I'm trying find reverse cummilative 

 

Thank you 

Harish

Labels (4)
1 Reply
Chanty4u
MVP
MVP

May b this 

Rangesum(Above(Total Sum(Aggr(

If($(vMTD_Actual_CVR) >= 5, ($(vMTD_Domestic) * 5) + ($(vMTD_International) * 10),

(($(vMTD_Booking%) * ($(vMTD_Domain%) * 5)) + (($(vMTD_Booking%) * (1 - ($(vMTD_Domain%))) * 10))),

0, Rowno(Total))), 0, Rowno(Total)))