Skip to main content
O
Oscar
November 20, 2023

Current Quarter v Prior Quarter BI Viewer - A Summary Expression is Expected

  • November 20, 2023
  • 1 reply
  • 0 views

Hi All-

We are trying to create a BI Viewer to compare Current v Previous Qtr OPEX.

We look at the end date (only two end dates possible of course) to create a Current QTR measure (max end date) as below. However, I can't seem to get the syntax for the measure correct. Not sure what I am missing which is generating the error below: A Summary Expression is Expected


Oscar_0-1700488240249.png

 

 

1 reply

J
JackLacava
November 21, 2023

You're comparing a string or date [EndDate] with the True/false returned by [Scenario] == 'Actual'. I suspect you want something more like

If( 
 ([EndDate] == max([EndDate]) ) 
   and ([Scenario] == 'Actual') , 
[Amount], 0)

This said, I don't remember if that Max() operations will actually work like you expect it to, nor whether you can actually use == like that.

O
OscarAuthor
November 27, 2023

Thank you for the reply ... I will attempt a different approach to group the data.

Terms & ConditionsAccessibility statement