YEARVALUE function

Syntax

YEARVALUE(x)

where:

x: Source line item or property to be summarized.

Format

Input Format Output Format

x: Number

Number

As from above we can see input & output format should be number for YEARVALUE function. Can anybody explain how this function is working for boolean format (please find the attachment)

yearvalue_58602.docx

Accepted answers

All comments

JaredDolich

@anupgade

What an interesting discovery!

I tested this myself and it works as you suggest. I did have to change the summary to "ANY" in order to get the yearvalue though.

I guess in my mind this is not a bug but kind of an easter egg.

It's possible the Boolean is resolved in memory as numeric or there's some type of polymorphism allowing you to use a different format type.

Nice Catch.

Here I use YearValue on a numeric value and a Boolean.

Grid

Blueprint: Summary

Blueprint formulas

anupgade

Thanks @JaredDolich

But still, what would be the relevance of using the YEARVALUE function in a boolean format?

rob_marshall

@anupgade ,

If you have any month as a True, with ANY as a summary it will be true as @JaredDolich stated. Why would you use this? Again, checking to see if anything was checked within that year.

Rob

JaredDolich

@anupgade

Just adding to what @rob_marshall had to say.

You discovered something that isn't documented so it opens up the opportunity to think about use cases.

I typically work in the supply chain:

Here's how I might use it.

Set a Boolean to check if an item was ever out of stock during the year.

As we know, Booleans are fastest and most efficient data types to work with.

Use the Yearvalue to filter on the items that had at least one stock out during the year.

Do missed sales analysis on those items.

To be honest, I can think of a lot of use cases. Like counting how many items had stock outs during the year, number of vendors that had late shipments, receipts that took longer than a normal leadtime, forecasts that are below the lower control limit, above the higher control limit....

So this is quite a discovery @anupgade!!

ChrisAHeathcote

A often used tool in my models is the ability to select a year via a boolean check on a dashboard. This line item is formatted as a year time frame which feeds a time property model to allow the user to filter for that particular year.
Without YEARVALUE() the time property module, dimensioned by date or month time period will not know where to go to find the condition.

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…