Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

computed field in view

Posted on by 50

Hi guys,

I have created a view in AOT which has data source query (static AOT Query)

i have calculated sum of purchline amount that is correct and it gives correct result,

but somebody guide me how i will calculate multiplication of two fields in AOT View like Tsql (Sum(pl.LINEAMOUNT)*sum(pl.PURCHQTY)))

and subtraction of ,(sum(pl.PURCHQTY)-sum(vpst.QTY))'Balance Receipt Qty'

  • Suggested answer
    Israel Gonzalez Profile Picture
    Israel Gonzalez 708 on at
    RE: computed field in view

    Hi makdax2012r3,

    You can use the table fields for doing calcs. Check out this: https://community.dynamics.com/ax/b/axwithisraelgonzalez/posts/work-with-computed-columns-on-a-view

  • makdax2012r3 Profile Picture
    makdax2012r3 50 on at
    RE: computed field in view

    i have already seen this walkthrough but plez tell me how i ac do this Tsql (Sum(pl.LINEAMOUNT)*sum(pl.PURCHQTY)))

  • Suggested answer
    huijij Profile Picture
    huijij 19,803 on at
    RE: computed field in view

    Hi makdax2012r3

    Please refer to the MS document about adding a Computed Column to a View:

    docs.microsoft.com/.../walkthrough-add-a-computed-column-to-a-view

  • Suggested answer
    Komi Siabi Profile Picture
    Komi Siabi 12,407 Super User on at
    RE: computed field in view

    Hello Mark,

    I personally haven't being using computed columns on view. Something I would explore more. However, for me I would have created a display method on the view where I will do my x++ select statement to get the sum and compute.

    I can display this method on my form, ssrs report...

    My own suggestion

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans