nathan_rudman 
-
Re: Truncate decimals but not round
If you do not want to round then your only other option is text cutting. You can do LEFT(TEXT(number line item),5) You can have an IF statement to not always take the 5 first (2.229) but the first th…1 -
Re: Truncate decimals but not round
truncate isn't the right word, you want to round down to a specific decimals. In which case Jared anser's is correct, round allows you to do that https://help.anaplan.com/anapedia/Content/C…1 -
Re: Only summarise at lower levels of hierarchy
something to know as well, it is possible to detect the level of a composite hierarchy and thus you could set a specific level to 0. not that I recommend it here, just giving the art of possibles1 -
Re: Convert Date with Week Format to Last day of month with a Date Format
Hi, it would be easier with a monthly calendar but we it still easy achievable with the DAYSINMONTH formula You can do like this: (the first screenshot is by days but it is the same with weeks as bel…1 -
Re: Dimension Mismatch
Hi, do you know that you can put pictures in the post ? it would be easier for us ! When a target module references a source module and they don't have the same dimensions, you need to indicate …1
