Forum Discussion
omarelmb123
Helper I
Helper I'DATEADD' only works with contiguous date working with multiple year selection
Hello, im using a simple formula and calculaing leavers for each month and comparing it by year. The rule is the leavers on the last day of the month should be counted as leavers for the next month ...
MNedix
Solution Sage
Solution SageHi,
Create a dedicated Date table with unique (and contiguous dates), create a relationship between the new date table and the date column on the Leavers table and then use the new Date in the formula.
omarelmb123Helper I
Helper II have already a table with unique values with 1 to Many relation and unidirectional . the thing is the formula is working but when i add a third dimension, for example location then i got the error