Hi

Above the FR was working fine with comparison for Current Year & Last Year in Column H & J. 

But we want to add in the balance for each branch - J001, J002, J003 & J004. which using the segment 2 before the Current year.

So I have tested with one branch J001 in Column G and with the formula =FRAMTA("NETYTD","","(ACSEGVAL02 = ""J001"")") to call out the results.

But the result in Column G turned out wrongly as show below. For Column H & J are correct.  

Which part of the formula i did wrong? Any suggestion? 

We are using Sage 300 2017.