nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

742934_en-US

liliconcom

Formula application

IF(MONTH(A151)=MONTH(A150),NA(),COUNTIF(W151:W181,1)*100/(COUNTIF(W151:W181,1)+COUNTIF(W151:W181,0))) . This is a formula applied in excel to create a new column, where Column A has date & column W contains only 0 & 1 as values. How to apply this same formula in JMP if we have columns A & W values.

Advanced Statistical Modeling

Re: Formula application

Your request is a bit unclear, but I think I am close to what you want - see attached file. I created a column of random dates and then sorted them. The W column is a random vector of 0 and 1 values. The formula counts the fraction of 1 values in the next 30 days after a change in months. If this isn't what you want, can you either explain it more clearly or post a simple example. Remember, JMP is not a spreadsheet, so Excel formulas like CountIF don't always translate well.

Comments

There are no comments yet