Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Why this query always return the value of the 1st expression
Pick(Match(vDateView=1 and vMeasure=2 and vIFRS = 1 and v_Wastage=2,
vDateView=1 and vMeasure=2 and v_Wastage=1 and vIFRS = 2,
vDateView=1 and vMeasure=2 and v_Wastage=2 and vIFRS = 2 ,
vDateView=2 and vMeasure=2 and vIFRS = 1 and v_Wastage=2,
vDateView=2 and vMeasure=2 and v_Wastage=1 and vIFRS = 2,
vDateView=2 and vMeasure=2 and v_Wastage=2 and vIFRS = 2 ,
vDateView=1 and vMeasure=10 and vIFRS = 1 and v_Wastage=2,
vDateView=1 and vMeasure=10 and v_Wastage=1 and vIFRS = 2,
vDateView=1 and vMeasure=10 and vIFRS = 2 and v_Wastage=2,
vDateView=2 and vMeasure=10 and vIFRS = 1 and v_Wastage=2,
vDateView=2 and vMeasure=10 and v_Wastage=1 and vIFRS = 2,
vDateView=2 and vMeasure=10 and v_Wastage=2 and vIFRS = 2
),
Sum({<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))}, Acct_Type -= {'IFRS - Reversal'} >} CPV * Value_Used),
Sum({<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))},RecordType-={'WASTAGE - COSTING'}>} CPV * Value_Used) ,
Sum({<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))} >} CPV * Value_Used) ,
Sum({<FIN_YR_NO={$(v_Max_Year)},Acct_Type -= {'IFRS - Reversal'}>} CPV * Value_Used),
Sum({<FIN_YR_NO={$(v_Max_Year)},RecordType-={'WASTAGE - COSTING'}>} CPV * Value_Used),
Sum({<FIN_YR_NO={$(v_Max_Year)} >} CPV * Value_Used) ,
Sum({<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))}, Acct_Type -= {'IFRS - Reversal'} >} CPV * Value_Used)/Sum(TOTAL <YR_MTH_NO>{<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))}, Acct_Type -= {'IFRS - Reversal'} >} CPV * Value_Used),
Sum({<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))},RecordType-={'WASTAGE - COSTING'}>} CPV * Value_Used)/Sum(TOTAL <YR_MTH_NO>{<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))},RecordType-={'WASTAGE - COSTING'}>} CPV * Value_Used) ,
Sum({<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))} >} CPV * Value_Used) /Sum(TOTAL <YR_MTH_NO> {<CAL_YEARMONTHINDEX={$(=Max(CAL_YEARMONTHINDEX))} >} CPV * Value_Used) ,
Sum({<FIN_YR_NO={$(v_Max_Year)},Acct_Type -= {'IFRS - Reversal'}>} CPV * Value_Used)/Sum(TOTAL <YR_MTH_NO> {<FIN_YR_NO={$(v_Max_Year)},Acct_Type -= {'IFRS - Reversal'}>} CPV * Value_Used),
Sum({<FIN_YR_NO={$(v_Max_Year)},RecordType-={'WASTAGE - COSTING'}>} CPV * Value_Used)/Sum(TOTAL <YR_MTH_NO> {<FIN_YR_NO={$(v_Max_Year)},RecordType-={'WASTAGE - COSTING'}>} CPV * Value_Used),
Sum({<FIN_YR_NO={$(v_Max_Year)} >} CPV * Value_Used) /Sum(TOTAL <YR_MTH_NO> {<FIN_YR_NO={$(v_Max_Year)} >} CPV * Value_Used)
)
because you are writing in an order
I just realized there is no field name at the beginning of the pick match
So can one use Pick Match with variables only ?