Count and Set Analys

[#1]

Hello,

I cannot get this Count working, what do I do wrong?

= Count({< KundNr = {"=Sum( {$<$(vSetRolling12)>} $(vNettoFörs) )> $(vOmsG)"}>}Distinct KundNr)

kindly

Håkan

[tresesco]

Without knowing your variable definitions it would be hard to even guess. Could you post your qvw sample?

[sunny_talwar]

I agree with tresesco‌ but for starters may be try this:

=Count({< KundNr = {"=Sum( {$<$(vSetRolling12), $(vNettoFörs)>} $(vOmsG)"}>}Distinct KundNr)

[nagarjuna_kotha]

Can u please share the sample file that shows ur issue.

[Anil_Babu_Samineni]

I really Don't no, Why do you use the Sum

Count({< KundNr = {"$(=RangeSum('vSetRolling12','vNettoFörs','vOmsG')"}>}Distinct KundNr)

[#6]

Hello again,

this is the error I get:

All the variables works by themselves, it´s when I try to compare with variable vOmsG it fails.

I tried Sunny T:s change but got the same error.  I will try to create an example qvw.

kindly

Håkan

[sunny_talwar]

Do you happen to have double quotes within any of your three variables? I think it would be helpful if we can see how you define your three variables?

[#8]

Hello,

here are my variables:

[Anil_Babu_Samineni]

For 1st Variable Remove PeriodID

[sunny_talwar · Accepted solution]

Try changing this to single quotes