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