Skip to Content
0
Former Member
Jun 17, 2013 at 06:54 AM

BEx Formula.

43 Views

Hi All,

Column: =IF(AND(Z39<>AH39,SUMIFS($Z:$Z,$G:$G,$G39)=SUMIFS($AH:$AH,$G:$G,$G39)),AI39-AA39,0)

The column should show the output of this Excel formula.

where,

Z: Quantity field (previous month)

AH: Quantity field (current month)

G: Material Number

AI: Amount (previous month)

AA: Amount (current month)

Please help me out how i can design this in BEx Query designer.