Beast Mode Numbers Sorting Improperly
Hi all - I create the folling simple beastmode to find the number of days between two dates:
The formula validated and the output reflected the correct number of days between the two dates - great!
The problem is that the card that the beastmode is in does not seem to recognize the value of the number, even though the data type shows up as a number and falls under the "measures" category. When sorting, only the first number seems to matter - for instance, 1,000 comes before 2, and 2,000 comes before 3, etc. Does anyone know what could be causing this?