Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe like this,
=(if($(vTaskOneDay),1, $(vExpectedPCG))) & (if($(vTaskOneDay),1, $(vExpectedPCG)))
Hi Prasad,
Try to pick function with the help of wildmatch.
Thanks
Arvind Patil
Hi Michele,
I tried =(if($(vTaskOneDay),1, $(vExpectedPCG)))
but it doesnt work.
Regards,
Prasad
Try removing the = character at the front of the expression in the variable.
Its not working
Would it be possible to share you application or a sample?
You mentioned set analysis, how the complete expression looks like? Is it a Count(), a Sum(), an Aggr() ?