Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Calculating Margin % f...

Calculating Margin % for Multiple Rows & Columns?

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello, I can calculate margins for multiple rows using the following formula for Net Income / Revenue.

B=B.NI/B.REV,C=C.NI/C.REV,D=D.NI/D.REV,E=E.NI/E.REV,F=F.NI/F.REV,G=G.NI/G.REV,H=H.NI/H.REV,I=I.NI/I.REV,J=J.NI/J.REV,K=K.NI/K.REV,L=L.NI/L.REV,M=M.NI/M.REV,N=N.NI/N.REV

However, if i want to calculate multiple rows say (NI + Interest) / Revenue. What is the correct syntax, using the same formula structure? I'm fine for 1 column using (@A+@B)/@C but not sure what the correct syntax is if i have to use the B=B. and C=C. syntax.

Your advice is very much appreciated. Great forum!

Thanks

*This post is locked for comments

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Calculating Margin % for Multiple Rows & Columns?

Worked perfectly, thank you very much. Non-printing rows are a great tool.
Verified answer

babubaskaran@outloo... on at

Like (0)

Report

RE: Calculating Margin % for Multiple Rows & Columns?

Hi,

I think you can add the first formula in one row (NI + Interest) as non printing row and use that row / Revenue. Have you tried this way.