topic Re: Expression Error in App Development

Expression Error

Sam_1985 — Thu, 17 Nov 2022 06:13:53 GMT

=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'

Re: Expression Error

brunobertels — Thu, 17 Nov 2022 08:31:31 GMT

You don't need set expresion

try

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

Re: Expression Error

Sam_1985 — Thu, 17 Nov 2022 08:45:42 GMT

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

Re: Expression Error

Sam_1985 — Thu, 17 Nov 2022 09:43:50 GMT

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??

Re: Expression Error

Sam_1985 — Thu, 17 Nov 2022 09:45:15 GMT

do you have any idea?

Re: Expression Error

vinieme12 — Thu, 17 Nov 2022 10:18:55 GMT

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

Re: Expression Error

brunobertels — Thu, 17 Nov 2022 11:02:59 GMT

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 ?