calculate the number of weeks based on the selection

[#1]

Hi all

I want to calculate a weekly-Runrate based on the month selected.

Currently I use this formula, but this takes the full year

=sum({<[Fact.Type] = {'Sales'}>}Fact.Net_Rev_EUR)

/

week(today())

How can I calculate the number of weeks based on the selection?

[rubenmarin · Accepted solution]

Hi Oliver, you can count the weeks between the min as date:

Ceil((max(Date)-Min(Date))/7)

or

Floor((max(Date)-Min(Date))/7)

[#3]

Thanks a lot !

cheers

Oliver