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!!
