cancel
Showing results for 
Search instead for 
Did you mean: 

max of two dates across two dimensions

Former Member
0 Kudos

Hello,

I need to calculate the Max for two dates from 2 dimensions as shown in the image. In other words, I need to replicate the excel Max functionality.

Is there a way to achieve this in Webi?

Thank you in advance,

Accepted Solutions (1)

Accepted Solutions (1)

mhmohammed
Active Contributor
0 Kudos

Hi,

You can always write an If Then Else statement as

=If([Action Date]>[Comment Date]) Then [Action Date] Else [Comment Date]

I tested it, it works.

Thanks,

Mahboob Mohammed

Answers (0)