Can we use this in set analysis

[varunreddy]

Hi,

I am trying to convert this into set expression. Is there a way to do it?

if([Pull Type]='M' or [As of Date] = '$(vmaxDate)', [As of Date])

Cheers!

[sunny_talwar]

May be this:

=Only({<[Pull Type] = {'M'}, [As of Date] = {"$(vmaxDate)"}>} [As of Date]) or

=Only({<[Pull Type] = {'M'}, [As of Date] = {"$(=vmaxDate)"}>} [As of Date])

[varunreddy]

Sunny,

I tried this, but it didn't work, so came up with if syntax

[sunny_talwar]

Can you share a sample where it is not working? What is the expression for your variable vmaxDate? May be that is the issue.

[varunreddy]

vmaxdate = max(Date)

[Qrishna]

Only({$<[Pull Type] = {'M'} + [As of Date] = {"$(vmaxDate)"}>} [As of Date]) 

edit:  The"+"-sign is used for OR in set analysis

[sunny_talwar]

Try this may be to find the max date where Pull Type = M

=Max({<[Pull Type] = {'M'}>} [As of Date])

[Qrishna]

I guess this expression returns the values  for [As of Date] where [Pull Type] = {'M'} and  [As of Date] = {"$(vmaxDate)"}

[varunreddy]

I need Date where [Pull type] = 'M' or [As of Date] = max([As of Date])

[Qrishna]

try using

Only({$<[Pull Type] = {'M'} + [As of Date] = {"$(vmaxDate)"}>} [As of Date])