Internal Functions (Count, Min, Max...)

Edmund Andersson · Post by **Edmund Andersson** » Tue Feb 15, 2011 11:35 am

Hi!

How should these functions be used...

For example, I have a table (lets say MachineStatus), in MachineStatus i have two columns (LogDt = Logdate (1 every minute), Status ("1" if up running)).

So now I would like to print in a report how many Minutes in a day the machine has been up running
(I know there is 1440 minuts per day so it would be simpel as Count(Status = 1)/60 + ":" + Count(Status = 1)%60)...

But I cant get the Count function to work, how shuold I implement this

And the Min/Max function I cant get to function as I expect them (the column holding the status varible is a charchar, so do I need to tryPrase it like {Max(TryParseDouble(A7A3_Drift.Status))})...???

Best Regards

Edmund

Edmund Andersson · Post by **Edmund Andersson** » Wed Feb 16, 2011 6:28 am

Any working example?

Post by **Ivan** » Wed Feb 16, 2011 9:34 am

Hello,

We need some additional time to check the issue.

Thank you.

Edmund Andersson · Post by **Edmund Andersson** » Fri Feb 18, 2011 12:37 am

Any luck? :dreamer:

Edmund Andersson · Post by **Edmund Andersson** » Mon Feb 28, 2011 6:56 am

Hi guys!

Have you had any time to check on my problem?

Any new build/realse scheduled?

Regards Edmund

Post by **Ivan** » Wed Mar 02, 2011 2:16 am

Hello,

We have added a new conditional functions like CountIf, SumIf, AvgIf. Now you can use the following expression, for example:

Code: Select all

{(int)(CountIf(MachineStatus.Status = 1)/60) + ":" +  CountIf(MachineStatus.Status = 1)%60}

Another examples:

Code: Select all

{CountIf(DataBand1, DataSource1.Field == true)}
{SumIf(DataBand1, DataSource1.FieldForSum, DataSource1.FieldForCheck == 1)}

The patch will be available in the prerelease build from 1-Mar-2011.

Thank you.

Edmund Andersson · Post by **Edmund Andersson** » Wed Mar 02, 2011 3:11 am

Thanks Ivan!

I´ll be looking foward to this...

Regards

Edmund

Post by **Andrew** » Wed Mar 02, 2011 7:51 am

Hello,

Let us know if you have additional questions.

Thank you.

Edmund Andersson · Post by **Edmund Andersson** » Wed Mar 16, 2011 1:08 pm

Have the function been added?

I´ve downloaded the prerelease from yesterday (2011.03.15) but I can´t see them in the function list or get it to work...

Regards Edmund

Post by **Vladimir** » Thu Mar 17, 2011 2:06 am

Hello, Edmund

The specified functions should work in the latest prerelease build. At this moment did not added a list of functions in the expressions editor, we will add it in the next prerelease build.

Thank you.