# James Hayward

• Total activity 93
• Last activity
• Member since
• Following 0 users
• Followed by 0 users
• Subscriptions 32

## Activity overview

Latest activity by James Hayward
• James Hayward commented,

Thank you Rainer... How correct you are, so many ways to skin a rabbit! Just want to thank you for your help again on previous calc question, where we are using a similar javascript Calc. The hel...

• James Hayward commented,

Hi Rainer, Thanks for getting back... The Min and Max dates will be fixed dates, so I would manually write these dates in to the formula. As I would have one Calculation Field (12 in total) ...

• James Hayward created a post,

### IF date is between X and Y then SUM

Basically using something like below I want to be able to create a SUM based on pulling the data from another App into the report APP. If 28/04/1974 is between 01/01/1960 and 30/11/1980 then SUM,...

• James Hayward commented,

Thank you @Rainer Have cleaned it up and seems to working like magic. var expType = @All of Program ; // from your leave app var expAmt = @All of Expense Claim; // from your leave app var expSum...

• James Hayward commented,

Adding to my question.. I have tried the following Calculation by @Rainer though I get a zero result var expType = @All of Program ; // from Expense App var expAmt = @Sum of Expense Claim; // fro...

• James Hayward created a post,

### Filtering across APP, to Return a @SUM of Numbers for category.

In one App (A) I have a collection of expense submitted by employees, in which they assign a 'category' to the type of expense it is, (Flight, Taxi, Meals) In the second App (B) I have total Sum o...

• James Hayward commented,

Hi Jan, Thank you for taking the time to assist, appreciate it. It works! Only thing is that I needed to remove the () after .length So if anyone else needs to work out how to count the fields...

• James Hayward created a post,

### Count an ARRAY (Category Items)

How can I count the number of active/selected fields within a category by using a java calculation?

• James Hayward commented,

Hi Anthony - Did you get a answer for this? Have similar problem which I'm trying to fix. Need to count the number of selections are made in our categories. James

• James Hayward created a post,

### Javascript to count active categories selected.

Okay there might be a simple way. But trying to count a field that has active categories selected. EG someone selects "Advocate" + "Canning" + "Fremantle Gazette" the result would be three (3) co...