vMaxMonth variable is not working in Expression.

[renuka_sasikumar]

Hi,

When I use Count({$<MonthNumber={'$(vMaxMonth)'}>}Data) where my

vMaxMonth=Max({$<[Fiscal Year]={'$(=Max([Fiscal Year]))'}>}MonthNumber)

it's not working.

I know its very simple, but I think I am missing out something.

Can anyone help on this.

I want to show MaxMonth Data in a TextObject.

Regards,

Renuka S

[prat1507]

Hi Renuka

Try replacing $(vMaxMonth) with vMaxMonth. I hope it might work.

Regards

Pratyush

[renuka_sasikumar]

Thanks Pratyush for your prompt reply.

Do you mean to say like this

Count({$<MonthNumber={'(vMaxMonth)'}>}Data_Status)

If so, then also its not working.

Regards,

Renuka S

[prat1507]

Remove the brackets, just keep the variable name.

[renuka_sasikumar]

No still not working.

Regards,

Renuka S

[prat1507]

Could you please share a sample app.

Regards

Pratyush

[renuka_sasikumar]

Hi,

Due to some reason I won't be able to share the sample app.

Regards,

Renuka S

[prat1507]

Please find the attached app for your reference.

Regards

Pratyush

[jonathandienst]

I think you were very close. Try this:

=Count({$<MonthNumber = {"$(=$(vMaxMonth))"}>} Data)

[jonathandienst]

Or redefine the variable with a leading = sign:

=Max({$<[Fiscal Year]={'$(=Max([Fiscal Year]))'}>}MonthNumber)

Then use:

=Count({$<MonthNumber = {$(vMaxMonth)}>} Data)

This assumes that MonthNumber is a simple integer.