Variable in Set Analysis

[bimanbeginner]

Hi There

I am trying to calculate a percentage out of two formulas, The set analysis doesn't seem to be working with the variable please assist.

vMTDCALC = =


(Sum({<Survey={'Survey1'}>}Excellent)/(Sum({<Survey={'Survey1'}>}Poor)+Sum({<Survey={'Survey1'}>}Average)+Sum({<Survey={'Survey1'}>}Excellent))*0.70

+

Sum({<Survey={'Survey2'}>}Excellent)/(Sum({<Survey={'Survey2'}>}Poor)+Sum({<Survey={'Survey2'}>}Average)+Sum({<Survey={'Survey2'}>}Excellent))*0.30)

In my text box I have

=Sum({<FIN_YR_MTH_NO={$(vMaxFinYrMthNo)}>}$(vMTDCALC))

The Calculation of sum(vMTDCALC) works but it seems to be ignoring my set analysis... it doesn't look at the max year at all, do I need to some how use the Aggrr function?

Your assistance is appreciated.

[vikasmahajan]

Can you try with this

=Sum({<FIN_YR_MTH_NO={$(vMaxFinYrMthNo)}>}  (=$(vMTDCALC)) )

[prat1507]

Use this

=Sum({<FIN_YR_MTH_NO={'$(vMaxFinYrMthNo)'}>}$(vMTDCALC))

Please specify the quotes inside the curly braces.

Regards

Pratyush

[bimanbeginner]

Hi Vikas,

This displays an error

[bimanbeginner]

Hi Pratyush

The max date variable is being ignored here too...

[prat1507]

What is exactly written in your max Month variable?

Regards
Pratyush

[bimanbeginner]

=Max(FIN_YR_MTH_NO)

[prat1507]

Use =date(Max(FIN_YR_MTH_NO))

Regards
Pratyush

[bimanbeginner]

This will break the variable, The current variable is working correctly...

[prat1507]

Store your variable  vMTDCALC  without '='

vMTDCALC

(Sum({<Survey={'Survey1'}>}Excellent)/(Sum({<Survey={'Survey1'}>}Poor)+Sum({<Survey={'Survey1'}>}Average)+Sum({<Survey={'Survey1'}>}Excellent))*0.70

+

Sum({<Survey={'Survey2'}>}Excellent)/(Sum({<Survey={'Survey2'}>}Poor)+Sum({<Survey={'Survey2'}>}Average)+Sum({<Survey={'Survey2'}>}Excellent))*0.30)

and then use your expression.