Electronic Reporting - Insert comment in Formula editor

(3) Share

Report

Posted on by petya.topalova

Hi,

Do you know how to add a comment in the Formula editor?

I want to comment a line and keep the formula without deleting it.

Thanks a lot!

Petya

I have the same question (0)

All responses (11)

Answers (3)

Verified answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Hi petya,

You can add text/comment formula editor as follows:

"Text"

for example following element is binded with fixed text:

Was this reply helpful? Yes No
petya.topalova 28 on at

Like (0)

Report

Thank you very much, Alireza,

I want to comment the code, so that it is not taken into account.

Like some of those used in other programing languages:

 or

// text, code, or

/* text, code */, or

the one used in excel: +N("text, code") .

How can I do it in the Formula editor?

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Hi petya,

I think that you can apply the IF function for this requirement. If the text is related to a data in a specific table, you can use the binded to data model, you can use the binded element. For example, I have binded customer group on CustTable to model.'Collection interest journal'.Customer.CustGroup:

IF(

OR(model.'Collection interest journal'.Customer.CustGroup="11",

model.'Collection interest journal'.Customer.CustGroup="12"),

NOT(model.'Collection interest journal'.Customer.AccountNumber=""),

model.'Collection interest journal'.Customer.VATNum<>"")

In the following example, I have created a validation formula that if customer group is 11 or 12 customer account number should not be empty and IF not the tax exempt number should be provided.

For more information about electronic reporting functions please check:

docs.microsoft.com/.../er-functions-logical-if

docs.microsoft.com/.../er-formula-language

Was this reply helpful? Yes No
petya.topalova 28 on at

Like (0)

Report

It is not what I am looking for. Thanks.

I just want to keep a code presented in a formula, yet not trigger it.

For example: model.Company.Name<>"" - I do not want to delete this, just want to leave it and put "false" instead.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Hi Pety,

You can use false or true instead.

Please try and give us a feedback if you need assist.

Was this reply helpful? Yes No
petya.topalova 28 on at

Like (0)

Report

Thanks, Alireza,

I want to keep the formula, but trigger only the "false" statement. Isn't this possible?

Best regards,

Petya

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Hi Petya,

It is possible.

You can share the formula if you need assistance.

Was this reply helpful? Yes No
petya.topalova 28 on at

Like (0)

Report

model.Company.Name<>"" -> this I want to comment, so that it is not taken into account, but still kept in the field.

false -> this should remain and be taken into account.

thanks a lot!

Petya

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

You can test following formular:

IF ( model.'Company info'.Name <>"",

"Comment",

model.'Company info'.Name)

Was this reply helpful? Yes No
Klara Calabro 18 on at

Like (0)

Report

Hi Petya, Hi Alireza

have you found some solution how to add developer comment in the formula editor without validation error? I have the same requirement.

In X++ we can comment out one or more lines of code with leading characters // or block comment multiple lines of code using the characters /* */

But how to do this in electronic reporting? By using this charachters I get the validation error of course.

Thank you to let us know.

Was this reply helpful? Yes No