How to modify my expression =(Sum({<rEVENUE={rEVENUE}>}Amount)) ?

[paulyeo11]

Hi All

(A)Below script generate field name = rEVENUE :-

If([Reporting Code]>=1 and [Reporting Code]<=15,'rEVENUE') as [rEVENUE],

it working fine for below expression :-

When i Click on field name = rEVENUE , it will select GL_CODE i want for Revenue.

=(Sum({<rEVENUE={rEVENUE}>}Amount))

(B) Below script generate field name = GL_SELECT :-

ApplyMap('MapGL',@1:16T,'9 OTHERS') as [GL_SELECT],

9 OTHERS
1 Revenue
2 COST
3 OTHER INCOME

When i Click on label name = 1 Revenue , it will select GL_CODE i want for Revenue.

But the expression is not working fine below :-

=(Sum({<[1 Revenue]=[1 Revenue]>}Amount))

May i know where go wrong ?

Paul Yeo

[paulyeo11]

Hi All

Should be some thing like below :-

=(Sum({<if(GL_SELECT=[1 Revenue])=if(GL_SELECT=[1 Revenue])>}Amount))

But it return null value.

Paul Yeo

[Vegar · Accepted solution]

Try these expressions:

=(Sum({<rEVENUE={'rEVENUE'}>}Amount))

=(Sum({<[GL_SELECT]={'1 Revenue'}>}Amount))

[paulyeo11]

Hi Vegar

Wow , your expression working fine, Thank you very much.

Paul Yeo