Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
I got it, I used it as
vMaxMonth=Max({$<[Fiscal Year]={'$(=Max([Fiscal Year]))'}>}MonthNumber)
Expression :
Count({$<[Fiscal Year]={"$(=Max([Fiscal Year]))"},MonthNumber={$(vMaxMonth)}>}Data)
Regards,
Renuka S
Hi Renuka
Try replacing $(vMaxMonth) with vMaxMonth. I hope it might work.
Regards
Pratyush
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
Remove the brackets, just keep the variable name.
No still not working.
Regards,
Renuka S
Could you please share a sample app.
Regards
Pratyush
Hi,
Due to some reason I won't be able to share the sample app.
Regards,
Renuka S
Please find the attached app for your reference.
Regards
Pratyush
I think you were very close. Try this:
=Count({$<MonthNumber = {"$(=$(vMaxMonth))"}>} Data)
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.