Expression Error

[Sam_1985]

=if({<LPO_AMOUNT-Sum(AMOUNT)>='0.1'>}(LPO_AMOUNT-sum(AMOUNT)))

this experssion not working any idea how to coun( lpo amount - sum(amount)) the condition is LPO_AMOUNT-Sum(AMOUNT)>='0.1'

[brunobertels]

Hi 

You don't need set expresion 

try 

if( LPO_AMONT-sum(AMOUNT) > 0.1 , LPO_AMONT-sum(AMOUNT) ) 

[Sam_1985]

thanks for this solution but even it's correct no value appear??see attached file

[Sam_1985]

now i know the issue 

one lpo amount have many amount paid 

i write it as 

=sum({<LPO_ID>}LPO_AMOUNT)-Sum({<LPO_ID>}AMOUNT)

but actually the number which appear is wrong even i do distinct before lpo amount ,is you have any idea??

[Sam_1985]

do you have any idea?

[vinieme12]

please provide more information

• on what you are trying to achieve
• a bit about your data, 
• sample data  or an app with sample data

makes it easier for members here to help you better

[brunobertels]

Sorry 

Don't see the issue 

If I understand you have one unique amount for LPO AMOUNT by LPO_ID but connected to several AMOUNT ? but you want to pick only one for your mesure sum({<LPO_ID>}LPO_AMOUNT)-Sum({<LPO_ID>}AMOUNT) ?

How do you know wich one it is ? it is the min amount max amount or is there another ID or dim you can use ?