variable inside set analysis

[prasadcm]

Hi All,

I have an expression like

=(if(vTaskOneDay,1, $(=vExpectedPCG)))

where in

vTaskOneDay =

=Match(

[Task Name],

'AP Explorer_SAN',

'FMG Explorer_SAN',

'Reload of Quotation Hit Rate',

'Reload of Sales Variance',

'Reload of Service lead time',

'Reference List',

'Reload of GL line items',

'SO Condition Type',

'Inventory report_SAN',

'Reload of Freight report',

'Customer Statistics Finland',

'Macgregor Migrated Project Life Explorer',

'Material Delivery Status',

'CashFlow_SAN',

'Production Order Dashboard',

'Production Order',

'Purchase Orders new Report  Reload',

'Reload Equipment Lead Time',

'Customs reporting Malaysia',

'Parts - Sales Dashboard_SAN')

when i dont make any selections i get values for  AP Explorer_SAN' has 2 which should be '1'

But when i select that certain task

it gives right value
I tried something like

=(if($(vTaskOneDay),1, $(=vExpectedPCG))) &  =(if($(=vTaskOneDay),1, $(=vExpectedPCG)))

but then i get '- 'value

How am i supposed to solve this?

Regards,

Prasad Mayekar

gwassenaar swuehl‌

[micheledenardi]

Maybe like this,

=(if($(vTaskOneDay),1, $(vExpectedPCG))) &  (if($(vTaskOneDay),1, $(vExpectedPCG)))

[arvind_patil]

Hi Prasad,

Try to pick function with the help of wildmatch.

Thanks

Arvind Patil

[prasadcm]

Hi Michele,

I tried =(if($(vTaskOneDay),1, $(vExpectedPCG)))

but it doesnt work.

Regards,

Prasad

[Gysbert_Wassenaar]

Try removing the = character at the front of the expression in the variable.

[prasadcm]

Its not working

[sunny_talwar]

Would it be possible to share you application or a sample?

[Miguel_Angel_Baeyens]

You mentioned set analysis, how the complete expression looks like? Is it a Count(), a Sum(), an Aggr() ?