Sum Between A Range Value

[Anonymous]

Hi All,

I have a scenario where I need to sum the Amount field based on the Group code(RKBIT1 is field name)

Now the amount for Group Code 1001 , 1006 1009, 1011 are coming correct, wherein I have used formula

     if(Flag=1,sum({<RVYEA4={"<$(=max(RVYEA4))"}>}Total_Amount)). (Group_Code Image1)

Now  I have a table Group Range listed below(Group_Code Image)

For Ex:-

In this I have to find the sum between the range i.e 1006-1009 means value for 1006 ,1007,1008 and 1009. Since value for 1007 & 1008 is '0' so total sum value should be 142790+(-16907)= 125883 i.e for 1006 & 1009 respectively. Kindly Suggest me how should I achieve it.

I have used this formula:-

Group Sum= if(Flag=1,sum({<RVYEA4={"<$(=max(RVYEA4))"},RKBIT1={">=$(=mid(SubField(Group_Range,'-',1),2,4))"},RKBIT1={"<=$(=mid(SubField(Group_Range,'-',2),1,4))"}>}Total_Amount)).

Kindly Help!!