Sales Analysis Column Templates - Formula syntax

(0) Share

Report

Posted on by Pixellume

Cannot find a Microsoft help page that shows syntax information to help me create a proper formula in the formula field in "Sales Analysis Column Templates".

Specifically, I'm trying to avoid a divide by zero. In power BI DIVIDE(C,B) works. Or in excel i can use IF(ISERROR(C/B),0,C/B)

7367.Untitled.jpg

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

We have this standard doc:

docs.microsoft.com/.../bi-how-create-analysis-views-reports

Hope this helps you already?

Was this reply helpful? Yes No
Suggested answer

Nirmala Karunarathna 277 on at

Like (0)

Report

How about changing columns like this? I tested it, it seems working.

Please click on yes if this suggestion works

Was this reply helpful? Yes No