Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I wrote the set to calculate the amount as
sum({<Company={A},Branch={'X','Y','Z'}>}Amount)+sum({<Company={B},Branch={'X','W','A'}>}Amount)
the problem is when i select the company A, then the amount should show
only for the Company A, but here the value shows both A and B irrespective of the Company selections.
Could anyone help me.
thanks in advance.
$ is entirely optional here.
Try this:
sum({<Company={A}*P(Company),Branch={'X','Y','Z'}>}Amount)+sum({<Company={B}*P(Company),Branch={'X','W','A'}>}Amount)
Be careful, though - if you select Company C (if there is one), nothing will get shown.
Hi,
Use the expression with $
sum({$<Company={A},Branch={'X','Y','Z'}>}Amount)+sum({$<Company={B},Branch={'X','W','A'}>}Amount)
Hope it helps
Celambarasan
$ is entirely optional here.
Try this:
sum({<Company={A}*P(Company),Branch={'X','Y','Z'}>}Amount)+sum({<Company={B}*P(Company),Branch={'X','W','A'}>}Amount)
Be careful, though - if you select Company C (if there is one), nothing will get shown.
Thank you very much....