Microsoft Dynamics NAV (Archived)

Flowfield exist()

(0) Share

Report

Posted on by Mehdi26

445

I have the below flowfield that I use for a Cuegroup.

I want to do following:

I want to add an Exist(). If Exist returns true, the CalcFormula must be as below else another one.

field(3; ServiceLine ; Integer)
{
  FieldClass = FlowField;
  Editable = false;
  Caption = 'Service Lines';                                         
  CalcFormula = count("Service Invoice Line" where("Document Type"=Filter(1));                           
         
}

*This post is locked for comments

All responses (2)

Answers (1)

Verified answer

Mehdi26 445 on at

Like (1)

Report
RE: Flowfield exist()

Hi Stefano

You are right. I found a work around for that.

I created a flowfield HeaderExist in table Service Invoice Line.

And in the table I used for my cues, I set the filter.

field(3; ServiceLine ; Integer) { FieldClass = FlowField; Editable = false; Caption = 'Service Lines'; CalcFormula = count("Service Invoice Line" where("Document Type"=Filter(1), "HeaderExist"=Filter(False)); }
Suggested answer

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (0)

Report

RE: Flowfield exist()

Not possible unfortunately.