Automate numbering months

[jadams123]

Hi:

I have a column that has a FY budget of $1MM

If the user selects Jan then $1MM * (1/12),

if the user selects Feb then $1MM * (2/12),

if the user selects March then $1MM * (3/12)

How can I do this?

Thanks, 

J

[jadams123]

Oh by the way I am a front end user. I have no access to loading data. I can only play around with dim and expressions. 

[Vegar · Accepted solution]

A month field are normally a dual value field, meaning it consist of both a text value (Jan, Feb ... Dec) and a numeric value (1, 2 ... 12). If your BudgetMonth field is a dual then you could use this expression:

Sum([FY budget] * BudgetMonth / 12)

[Vegar]

You might want to adjust the expression to this
Sum([FY budget] * $(=max(BudgetMonth)) / 12)

[HirisH_V7]

Might use getselectedfield in variable and use it there. So that user selection will effect there. or else max condition will work as default.