Help In Set Analysis Expression?

[sandeepprasad_j]

Hello Experts,

Can you please help me in writing the set analysis expression for the below if condition

If(vPer=12,sum([Amt]),(if(vPer=6, sum([Amt]))))

Thanks in advance

Cheers

Sandeep

[tresesco]

Your expression doesn't look very promising. Or, may be a set analysis would not help here much.

Could you explain the context? Is this expression being used in a chart (if yes, what are the dimensions?) or ..?

[mightyqlikers]

Hi Sandeep

use below expression

=Sum({<vPer={"6","12"}>}Amt)

Regards

Samwise

[jyothish8807]

Hi Sangeep,

Try like this:

sum({<vPer={'6','12'}>}[Amt])

Regards

KC

[PrashantSangle]

Hi,

Try like,

sum(if(vPer=12,Amt,if(vPer=6,Amt)))

Regards

[sandeepprasad_j]

Thanks for all the replies but the expression is like

If(vPeriod=12,sum([ 12 Amt]),(if(vPeriod=6, sum([6 Amt]))))

Cheers ,

Sandeep.

[PrashantSangle]

Hi,

[12 Amt] and [6 Amt] is fieldName??

Try like

sum(if(vPer=12,[12 Amt],if(vPer=6,[6 Amt])))

Regards

[sandeepprasad_j]

Hello Max,

Yes,those are field name [12 Amt] and [6 Amt]

and code like (001,002) is the dimension for the chart

[sandeepprasad_j]

The dimension is the Code like 001,002 and the expressions is a above

If(vPeriod=12,sum([ 12 Amt]),(if(vPeriod=6, sum([6 Amt]))))

vperios is variable

[ 12 Amt] and [6 Amt] are the fields

[PrashantSangle]

Hi,

Then try the solution which i have given in my earlier post.

Regards