Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
reporting_neu
Creator III
Creator III

QuarterStart(Max(... and QuarterEnd(Max(... in Dimension

Hello,

can anyone help me and tell me how to properly use QuarterStart Max and QuarterEnd Max here in the dimension?

 

if(VST_Call.AnlageDatum >=Quarterstart(Max([VST_CallPosition.AnlageDatum]),-1) and VST_Call.AnlageDatum <=QuarterEnd(Max([VST_CallPosition.AnlageDatum]),-1) and VST_Call.xCallart= 12 and VST_CallPosition.x_Klasse= 100, [VST_Call.QVT_Tender_ID], null())

 

If I use Aggr, I get QuarterStart from all quarters 😞

Aggr(Quarterstart(Max([VST_CallPosition.AnlageDatum]),-1)

 

Labels (1)
1 Solution

Accepted Solutions
reporting_neu
Creator III
Creator III
Author

I have the solution 😄

VST_Call.AnlageDatum >= Aggr(Quarterstart(Today(),-1), VST_Call.Callnumber)

View solution in original post

1 Reply
reporting_neu
Creator III
Creator III
Author

I have the solution 😄

VST_Call.AnlageDatum >= Aggr(Quarterstart(Today(),-1), VST_Call.Callnumber)