Total for variable

[Anonymous]

Hi

I have expression in table called 'vPass' that return result 0 or 1.

The vPass value is varible called 'vCalTrueFalse':

vPass =$(vCalTrueFalse).

I need to create total field for vPass in TextObject at dashboard.

I tried ' Sum($(=vCalTrueFalse))' but it give me an error: 'Nested aggregation not allowed'.

How can I do it?

Thanks!

[stabben23]

Hi Ravit,

And how does you Variable vCalTrueFalse looks like, is it a aggregation?

[Anonymous]

vCalTrueFalse = if($(vCalPassFail)='Pass', 1,0)

vCalPassFail =

if

((ParamID =98 or ParamID=99) and  $(vResult)<vMCS,'Fail',

if

((ParamID =102 or ParamID=100) and TestnameID<3 and $(vResult)<vGoodput, 'Fail',

if

(DashboardID =1 and $(vResult)<Connectivity, 'Fail',

if

(DashboardID =5 and $(vResult)<TotalSamplingTime, 'Fail',

if

((ParamID =102 or ParamID=100) and TestnameID>2 and $(vResult)<vGoodput_FDX, 'Fail','Pass')))))

[sdmech81]

Hi,

Plss attach sample..

[Anonymous]

Pass column represent variable vCalPassFail

vPass column represent variable vTrueFalse

What I need to do is show in text object the 'Pass' percentage.

[vinieme12]

Try

Sum( AGGR( SUM($(=vCalTrueFalse)) , YourTableDimensions))

or post the app

[Anonymous]

Its return zero.

How can I post the app?

[uacg0009]

Hi Ravit,

If possible could you please attach a sample file?

Because normally I think =sum(vCalTrueFalse)   is enough.

Thanks.

Aiolos Zhao

[Anonymous]

I cannot attached the file (security issue).

Any way, its still return zero.

See attach table and Grade, is there another way to calculate grade?

[vinieme12]

see this post on attaching a file

Uploading a Sample