
James Hayward
- Total activity 93
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 25
- 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...