Electronic reporting - filter by field value

(2) Share

Report

Posted on by MM-09100912-0

I am working on creation of Electronic report, I have requirement where i want to show only particular records based on field value. I have tried using formulas but it is throwing lot of errors. Can someone guide how should i proceed

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (1)

Adis 6,064 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

I would love to help you out, however, you need to provide some more details.

F.e.

Show us the configuration you are working on

What exactly do you want to display, which records do you want to show or whats the logic behind the filter of values you want to display?

Show as what you have tried so far

Show us the errors you mentioned.

Kind regards, Adis

If this helped, please mark it as "Verified" for others facing the same issue

Keep in mind that it is possible to mark more than one answer as verified

Was this reply helpful? Yes No
MM-09100912-0 59 on at

Like (1)

Report

Hi adis,

I have attached the Snips of my ER configuration, I want to set condition on NoteNumber field that it should not be blank. Trying to write formula in format mapping.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,948 Most Valuable Professional on at

Like (3)

Report

ISBLANK() function doesn't seem to exist. Consider using <> operator instead.

Was this reply helpful? Yes No
Suggested answer

Adis 6,064 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

IsBlank doesnt exsist. There is a similar function called ISEMPTY, however, this is used for Lists. If you open the formula designer, you can see on the right sight the functions, catagorized and with a link to MS Learn.

Just as an example if you need it.

I have a similar case, where I display data only if the number exists. The number here is a string, thats why I used the function LEN for Lenght, so it will display the data only if the lenght of the string is bigger than 0.

If you have a number you can remove the LEN including brackets and just write something like this.

In your case it would be @.NoteNumber > 0

But I dont know if NoteNumber is a sting or a real or an int.

Kind regards, Adis

If this helped, please mark it as "Verified" for others facing the same issue

Keep in mind that it is possible to mark more than one answer as verified

Was this reply helpful? Yes No