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'
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
i have already seen this walkthrough but plez tell me how i ac do this Tsql (Sum(pl.LINEAMOUNT)*sum(pl.PURCHQTY)))
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
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
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
