web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) total value of 2 or mo...

Microsoft Dynamics CRM (Archived)

total value of 2 or more dataset

(0) Share

Report

Report

Posted on by AKSHAY AURADKAR B

203

Hello,

I have one requirement i.e I have 2 fields which are "A" and "B"

Both are coming from a different dataset and table

i want the total of these

I have used exp =Sum(Fields!new_A,value,"DataSet1")+Sum(Fields!new_B.Value, "DataSet2")

but it is showing wrong value please help

I am using a crm online version

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

Hi Akshay,

Have a look here : docs.microsoft.com/.../bb630415(v=sql.100)

I think you need to do a nested sum i.e =Sum(Sum(Fields!Debit.Value,"Details1")+Sum(Fields!Credit.Value,"Details1"))

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

or simply on the column where you want the sum = just add expression as =(Fields!new_A,value,"DataSet1") + (Fields!new_B.Value, "DataSet2")

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

SA-08121319-0 4

#1

Calum MacFarlane 4

#3

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans