Data table Manipulation in Double Variable type

[rishabh.chauhan]

I have a datatable there is a column amount. amount is double type variable.
My query is that I want to found maximum Amount in all datatable.

I am using this Expression but it is not working.

Please Help…

Regards
Rishabh Chauhan

[Yoichi]

Hi,

Can you share the error message?

Regards,

[rishabh.chauhan]

No, error actually it is not accepting “Cdbl”. It is accepted only “Cint”.
What should I do.

[Yoichi]

Hi,

Can you hover mouse cursor on red exclamation mark?

And the above expression seems lack of ). Can you try the following expression?

dt_Data.AsEnumerable.Max(function(row) (cdbl(row("amount"))))

Regards,

[rishabh.chauhan]

[rishabh.chauhan]

[rishabh.chauhan]

How to get maximum amount In amount column.

[THIRU_NANI (NaNi)]

Hi!

Have a view on this thread

Find Maximum Value in the column

Hello, I want to identify the max value in the column how can i identify and put in the message box Please find the attached excel file in the max value i need to identify and publish in the message box. test.xlsx (8.3 KB) my flow as like this UsingMaxFunction.xaml (11.5 KB) please help to resolve the errors Thanks in advance

Regards,
NaNi

[Yoichi]

Hi,

Do you use Assign activity? Which type variable in the left side?

Regards,

[rishabh.chauhan]

thanks @THIRU_NANI
Code is working fine

Regards
Rishabh Chauhan

[rishabh.chauhan]

hi

In Assign activity Left side Variable is Double Type