-
Re: How to Create More flexible Calculations with Versions?
A technique to increase the calculation functionality with models with multiple Versions: This works well with switchover enabled models and with complex calculations which may need to vary with each…4 -
Re: Any equivalent to the Excel TODAY() function in Anaplan??
There isn't one, unfortunately. You can up vote the request for enhancement and hope it gets brought in: https://community.anaplan.com/forums/-/message_boards/message/29084765 -
Re: How to Calculate Months Difference between Two Dates
Michael - an alternative method is (Year(EndDate)*12 + Month(EndDate)) - (Year(StartDate)*12 + Month(StartDate)) This returns the number of calendar periods and is valid for some calculations. Best, …6 -
Re: Insert a Return into Dashboard Text Boxes
Hi Mark, Yes, you can add a carriage return in your dashboard text by typing ctrl+alt+return. This is supported on both Macs and PC's. Thanks, Katherine7 -
Re: Exclude Zeros From Average
You can do this by adding a line item to count the values you want to include, i.e.: add a line item 'Count' = If 'Value' <> 0 then 1 else 0. Then you can calculate the aver…9

