Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Did you mean:  Creator

## Use number of months up to today in Set analysis

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]

1 Solution

Accepted Solutions  MVP

May be try this

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

4 Replies  MVP

What is the issue that you are running into?  Creator
Author

Im getting;

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

But I cant see whats wrong.  MVP

May be try this

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

Ive tried alot...but apparently not that.

Thanks! Community Browser