Filter Flowfield Using Asterix

KARPURSHRIKANT · 2011-03-15

I wish to add a CalcFormula on a flowfield Document No='BR*'

eg.

On customer table and Payments(LCY) flow field

CalcFormula
-Sum("Detailed Cust. Ledg. Entry"."Amount (LCY)" WHERE (Document No='BR*',Entry Type=CONST(Initial Entry),Customer No.=FIELD(No.),Initial Entry Global Dim. 1=FIELD(Global Dimension 1 Filter),Initial Entry Global Dim. 2=FIELD(Global Dimension 2 Filter),Posting Date=FIELD(Date Filter),Currency Code=FIELD(Currency Filter)))

vijay_g · 2011-03-16

Can not do this as it works filters like in Table Relation. don't know what's logic behind it but if you want show only those entries will has to come with filter 'BR*' then do it by coding as form opening in customer balance field.

KARPURSHRIKANT · 2011-03-16

Thanks Vijay,

Well Coding it in form opening will filter on the table and will have no relation with the specific field. The purpose of this is that I just want to seperate cash receipts and bank receipts where BR* Is the documents starting with bank receipts..and the column will containg the sum of only bank receipts...

Pl advice if you have any alternate soluion...

rgds,

SHrikant K.

Savatage · 2011-03-16

Is it not working? Are you getting an error? What's the field NOT doing? Is it pulling more that BR* docs?

Or are you getting this?

Filter Flowfield Using Asterix

Comments

Categories