Aggreage (MAX) of a date using a valueexpression with an IF statement to select dates | Adobe Higher Education
Skip to main content
GrahamJarrett
GrahamJarrett
Level 4
May 23, 2023
解決済み

Aggreage (MAX) of a date using a valueexpression with an IF statement to select dates

  • May 23, 2023
  • 1 の返信
  • 765 ビュー

I want to get a column in a task report that puts the MAX date in when the task meets a criteria.  Ultimately I want a series of columns that grab the date off of a different task. I was trying a basic example but I never seem to get a date appearing in my aggregate…See simple example below

 

aggregator.displayformat=atDate

aggregator.function=MAX

aggregator.namekey=entryDate

aggregator.valueexpression=IF({wbs}=1,{entryDate})

aggregator.valueformat=atDate

displayname=

linkedname=direct

namekey=entryDate

querysort=entryDate

textmode=true

valueexpression=IF({wbs}=1,{entryDate})

valueformat=atDate

 

I am sure you used to be able to do this but it does not like it now. The aggregator on the regular column gets the "Whoops something went wrong" message.

このトピックへの返信は締め切られました。
ベストアンサー Doug_Den_Hoed__AtAppStore

 

Hi @grahamjarrett,

 

When I tried to switch what you've provided back to standard mode, I noticed this warning: 

Changing .valueexpression to .valuefield then (no surprise) did not recognize the formula, so instead, I deleted all the textmode, switched to standard mode, selected Entry Date, then on the Advanced options, chose "Max", which resulted as (sorted desc) follows:

 

 

So...closer; but whether an aggregator is (still) smart enough to also handle an IF statement remains to be seen (and something I don't recall doing, myself).

 

Regards,

Doug

 

 

 

 

1 の返信

Doug_Den_Hoed__AtAppStore
Community Advisor
Doug_Den_Hoed__AtAppStoreCommunity Advisor回答
Community Advisor
May 23, 2023

 

Hi @grahamjarrett,

 

When I tried to switch what you've provided back to standard mode, I noticed this warning: 

Changing .valueexpression to .valuefield then (no surprise) did not recognize the formula, so instead, I deleted all the textmode, switched to standard mode, selected Entry Date, then on the Advanced options, chose "Max", which resulted as (sorted desc) follows:

 

 

So...closer; but whether an aggregator is (still) smart enough to also handle an IF statement remains to be seen (and something I don't recall doing, myself).

 

Regards,

Doug

 

 

 

 

GrahamJarrett
GrahamJarrett作成者
Level 4
May 23, 2023

Thanks Doug, yes my other column highlighted showed exactly the same potential... but not there in the IF statement.

 

 

契約条件Accessibility statement

Loading footer...