web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... View Computed columns:...

Finance | Project Operations, Human Resources, ...

Suggested Answer

View Computed columns: How to Multiply three fields?

(0) Share

Report

Report

Posted on by DAX Dev

Hello,

How can I multiply 3 real type fields in computed column method?

SysComputedColumn::multiply takes only 2 arguments.

I tried something like this, but it returns error during the sync "Incorrect syntax near the keyword 'AND'".

SysComputedColumn::multiply(

SysComputedColumn::multiply(

SysComputedColumn::returnField( tableStr(MyView), identifierStr(WHSPhysDimUOM), fieldStr(WHSPhysDimUOM,Depth)),

SysComputedColumn::returnField( tableStr(MyView), identifierStr(WHSPhysDimUOM), fieldStr(WHSPhysDimUOM, Width))),

SysComputedColumn::returnField( tableStr(MyView), identifierStr(WHSPhysDimUOM), fieldStr(WHSPhysDimUOM,Height)));

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

A computed column method should return a string that contains a T-SQL statement that calculates the result that you want to show in the computed column. In T-SQL you can multiply three columns.

If you want to multiply A * B * C you can also split it to two multiplications: first A * B, then take the result of that and multiply it with C.

Does this help you?

Was this reply helpful? Yes No
DAX Dev on at

Like (0)

Report

Hi,

that's the logic actually what I try to achieve with my code above, but have a problem.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

You don't have to use SysComputedColumn::multiply() method because it doesn't fit your requirement.

Look at the source code of that method and you notice that you can easily write code that works with three fields.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 456 Super User 2025 Season 2

#2

Martin Dráb 429 Most Valuable Professional

#3

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans