I’m making some edits to a report that was already created. I found a measure with this formula:
(datediff(day,Expense_Reports.exprpt_info_recd,Expense_Reports.exprpt_check_date)/7)*2
Any guesses on what the '/7)*2 is trying to accomplish?
bull76 (BOB member since 2010-04-08)
Hi,
Datediff(day… gives the number of days between those 2 days. Then “/7” probably gives the number of weeks. Then “*2” - who knows?
Why don’t you ask the developer of this universe what’s the idea behind the measure?
Marek Chladny 
(BOB member since 2003-11-27)
Like Marek said, the /7 is probably for weeks. The *2 might be because there is something going on with the developers formulas that is cutting the appropriate answer in half. This is just a stab, but I know that I’ve created formulas before that gave half the answer I wanted, so as a quick fix I just multiplied by 2.
jmfuller (BOB member since 2010-02-16)
Thanks, I appreciate the help. The original developer is no longer at the company.
bull76 (BOB member since 2010-04-08)
Then maybe someone (an end user) who either requested this measure to be in the universe or someone who actually uses it in reports should help you.
Marek Chladny (BOB member since 2003-11-27)