Smart View Lesson 4: Member Selection and Aliases
Choose exactly the members you need with the Member Selection dialog: hierarchy browsing, search, filters by level and generation, aliases vs member names, and…
Read article →Excel, SAP, Oracle & automation tips — plus wacky facts
Choose exactly the members you need with the Member Selection dialog: hierarchy browsing, search, filters by level and generation, aliases vs member names, and…
Read article →Navigate cube data with the core ad hoc actions: zoom in and out, pivot dimensions between rows and columns, keep only and remove only,…
Read article →ODD rounds away from zero to the next odd integer — for example committee sizes that must avoid tied votes.
Read article →A 25-line Python script that moves files into Year/Month folders based on their modified date, with a dry-run mode so you can check before…
Read article →GCD returns the largest number that divides all inputs — for simplifying ratios and finding pack sizes.
Read article →EVEN rounds away from zero to the next even integer — handy when items come in pairs.
Read article →DAYS returns the number of days between two dates. Subtracting the dates (=B2-A2) gives the same answer.
Read article →LCM finds the smallest number all inputs divide into — when two repeating schedules line up again.
Read article →YEARFRAC returns the fraction of a year between two dates — for pro-rata interest, depreciation and exact age.
Read article →WORKDAY returns the date that is a number of working days before or after a start date, skipping weekends and holidays.
Read article →NETWORKDAYS counts Monday–Friday working days between two dates, optionally excluding a holiday list. NETWORKDAYS.INTL lets you choose the weekend.
Read article →FACT returns n! (1 × 2 × … × n). It grows absurdly fast: FACT(20) is already about 2.4 quintillion.
Read article →You blink around 15–20 times a minute.
Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry eyes.