How to get the max value from CDS

(0) Share

Report

Posted on by mahmoodhsaud

202

Hi Everyone,

I wanted to get the max value based on the Account sequence.

If you see in the below table, max value in account sequence 1 is 3, similarly for account sequence 2 is also 3 and after getting the max value I need to set it to 0.

Thanks in Advance,

Regards,

Mahmood

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

mahmoodhsaud 202 on at

Like (0)

Report
Copy link

Link copied!

Hi @eric-cheng can you help me out with this

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @mahmoodhsaud ,

Are you using CDS or Excel?

You can try sorting by the column in descending order and getting the first value?

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Was this reply helpful? Yes No
mahmoodhsaud 202 on at

Like (0)

Report
Copy link

Link copied!

Hi @eric-cheng,
I'm using CDS, the problem is in "Group Sequence" column we'll get more than one max value,
ex : If group1 has 1,2,3,4 and group2 has 1,2,3... I need to get 4 in group1 and 3 in group2

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @mahmoodhsaud ,

Ok, i may have misunderstood you earlier. You want to get the max group sequence value of each distinct account sequence?

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Was this reply helpful? Yes No
mahmoodhsaud 202 on at

Like (0)

Report
Copy link

Link copied!

Yea that's correct and replace the found value with 0

Was this reply helpful? Yes No
Verified answer

eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @mahmoodhsaud ,

You can have a look at this article as its trying to do something similar by grouping and then adding. In your case, you can look here for getting the max value instead of sum. You will need to output the rows to an array first.

I was looking at FetchXml and it could potentially be used to group and aggregate or at least group your results first. However, I dont know it well enough.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Was this reply helpful? Yes No