# Tag Archives: formula

## Tableau: sets

If you use a parameter in a condition to create a set you can use the formula [Dimension]=[Parameter] only on the referenced dimension, if you reference a different dimension then you need a aggregate condition like MAX( IIF([Dimension]=[Parameter],1, 0) ) … Continue reading

## Tableau: Distance formula

Calculate distance between 2 geographical points (great-circle distance): [VAR] * ACOS ( SIN( RADIANS([Origin-Latitude]) ) * SIN( RADIANS([Destination-Latitude]) ) + COS( RADIANS([Origin-Latitude]) ) * COS( RADIANS([Destination-Latitude]) ) * COS( RADIANS([Destination-Longitude]) – RADIANS([Origin-Longitude]) ) ) [VAR]= 3959 for miles [VAR]= 6371 … Continue reading

## Do you know these tricks?

During the last couple of months I have discovered some usefull tricks, which in turn are too small for a post on its own, so I have combined them into this one. Formula for calculating the maximum scale for chart … Continue reading

Filed under Components, Design, Excel | Tagged , , , , , | 1 Comment

## Ranking without repetitive values

Here’s a question I get asked a lot: “I’m trying to use the RANK function to sort the values in Column A, but, the problem arises when I have two or more cells with the same value. Then, the RANK … Continue reading

Filed under Excel | Tagged | Comments Off

## Formula: Weeknum() in Excel 2003

In Excel 2003 the Weeknum() formula will only be activated when the Analysis toolpack is installed. Go to Options -> Addin -> select Analysis Toolpack -> OK. The formula should work now. Furthermore if you use the Dutch version of … Continue reading

Filed under Excel | Tagged , , | 1 Comment

## Excel formulas translation NL-EN EN-NL

Excel sheet formula translation English to Dutch and vice versa. Functies_Excel_NL-Eng-VBA.xls

Filed under Excel | Tagged , , | 1 Comment