Use number of months up to today in Set analysis

[t_hylander]

Hi,

Im trying to make a forecast simply by taking the sum divide with number of months up till today and the multiply with 12.

But I cant get below to work, what is it Im missing?

[code]

=(sum({$<%Date=,Vecka=, [30minCHlID]={'73'}>} Value) / max({<%Date={$(=vToday)}>} Month) ) *12

[/code]

[sunny_talwar]

What is the issue that you are running into?

[t_hylander]

Im getting;

"Error: Error in set modifier ad hoc element list: ',' or ')' expected"

But I cant see whats wrong.

[sunny_talwar · Accepted solution]

May be try this

=(sum({$<%Date=,Vecka=, [30minCHlID]={'73'}>} Value) / max({<%Date={"$(=vToday)"}>} Month) ) *12

[t_hylander]

Ive tried alot...but apparently not that.

Thanks!