Set Analysis problem

[BootCam]

Hi,

I would like to create a straight table based on the example data in the excel file. The condition is mentioned in the excel file. I need to calculate the sum of Amounts only for the red marked IDs and Type field.

Thanks,

BC

[Vegar · Accepted solution]

Can I rephrase your condition to this?

Calculate the sum amount but exclude all amount for the IDs that is associated with type B.

If so then try this expression.

Sum({<ID=E({<Type={'B'}>}) [Aumount($)])

[BootCam]

Thank you so much Vegar!

-BC

[sugathirajkumar]

Sum({<Type={'A'}>}[Amount($)])