Need Help with EXPRESSION Sum of Product with set analysis

[#1]

I HAVE TO DO SUM OF PRODUCT...

SUM(only({<FLAG={'BP_Oretreatment'}>}Day_Value) * ONLY({<FLAG={'BP_ZNFEEDGRADE'}>}Day_Value)).

Error is showing as sum can not be used with only function .. Please help

[simsondevadoss]

try this : SUM({<FLAG={'BP_Oretreatment'}>}Day_Value) * ONLY({<FLAG={'BP_ZNFEEDGRADE'}>}Day_Value)

or store SUM({<FLAG={'BP_Oretreatment'}>}Day_Value) and ONLY({<FLAG={'BP_ZNFEEDGRADE'}>}Day_Value) in a separate variable and use it in the expression

[#3]

Its not helping the cause... any more suggestion

[#4]

kindly post your requirement in detail with sample application if possible

[#5]

Hi,

Try this.

sum({<FLAG={'BP_Oretreatment','BP_ZNFEEDGRADE'}>}Day_Value)

                               OR

sum(aggr({<FLAG={'BP_Oretreatment','BP_ZNFEEDGRADE'}>}Day_Value))

[mukesh24]

Hi Navneet,

Can u please explaint u r req. with sample example.

[#7]

PLEASE FIND THE ATTATCHMENT

[PrashantSangle]

Hi

Try without Only.

Try below

SUM({<FLAG={'BP_Oretreatment'}>}Day_Value) * Sum({<FLAG={'BP_ZNFEEDGRADE'}>}Day_Value)

Regards