cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ZK Frequent Visitor
Frequent Visitor

Date Forumla

I have a simple date function. The function was created some time back and it works fine. Now, when I copy the same function in the same model it does not recognize the columns which the same function is using. Does anyone have similar experience?

 

Thank you

 

date issue.jpg

2 ACCEPTED SOLUTIONS

Accepted Solutions
ThomasFoster Established Member
Established Member

Re: Date Forumla

This is because in your first example it is being evaulated as a column where as in the second it is a measure.

 

In a column you can use another column in the formula without aggregating due to the row context. Measures do not have row context so you will need to aggregate the columns. Which aggregation you should use depends on the model.

 

Highlighted
praiselyabraham Regular Visitor
Regular Visitor

Re: Date Forumla

Hi , 

 

As indicated in the error, you are creating a measure instead of a column , measure's work on aggregated format, where as columns work on row level. This is the reason for your error indicated.

 

Regards.

4 REPLIES 4
ThomasFoster Established Member
Established Member

Re: Date Forumla

This is because in your first example it is being evaulated as a column where as in the second it is a measure.

 

In a column you can use another column in the formula without aggregating due to the row context. Measures do not have row context so you will need to aggregate the columns. Which aggregation you should use depends on the model.

 

Highlighted
praiselyabraham Regular Visitor
Regular Visitor

Re: Date Forumla

Hi , 

 

As indicated in the error, you are creating a measure instead of a column , measure's work on aggregated format, where as columns work on row level. This is the reason for your error indicated.

 

Regards.

ZK Frequent Visitor
Frequent Visitor

Re: Date Forumla

Hi Thomas!

 

Thank you so much! I'm a bit embarassed that I did not think about that! Of course this has solved the problem. Thanks!!! Smiley Happy

ZK Frequent Visitor
Frequent Visitor

Re: Date Forumla

Thank you! This was indeed the problem!