Page 1 of 1

property condition not working

Posted: Fri Apr 29, 2022 10:38 am
by dmasterplan
Hi,

How to make property condition work when Sum (SumD) is involved?

I want the text component to turn red when Sum is less than zero. (highlighted in red)
SumD(DateDiff(dsPackages.tendercalldate,dsPackages.acttendcalldate).Days) < 0

I did it in the other text components (highlighted in blue),
(DateDiff(dsPackages.tendercalldate,dsPackages.acttendcalldate).Days) < 0
but didn't work when Sum is involved.

Please help. I badly need to solve this.

Re: property condition not working

Posted: Sat Apr 30, 2022 5:32 am
by dmasterplan
Hi,

I solved it anyway, I just put the name of the datasource as the first argument in SumD
from
SumD(DateDiff(dsPackages.tenderlettingdate,dsPackages.acttendletdate).Days) < 0
making it
SumD(dsPackages,DateDiff(dsPackages.tenderlettingdate,dsPackages.acttendletdate).Days) < 0
SumD(datasourceName,DateDiff(dsPackages.tenderlettingdate,dsPackages.acttendletdate).Days) < 0

Thank you

Re: property condition not working

Posted: Sat Apr 30, 2022 5:59 am
by Max Shamanov
Hello,

Ok.
Please let us know if you need any additional help.

Thank you.

Re: property condition not working

Posted: Sat Apr 30, 2022 7:17 am
by dmasterplan
Max Shamanov wrote: Sat Apr 30, 2022 5:59 am Hello,

Ok.
Please let us know if you need any additional help.

Thank you.
I will surely ask questions whenever I get issues and don't know how to resolve it :)

Great Thanks!

Re: property condition not working

Posted: Sat Apr 30, 2022 7:49 am
by Max Shamanov
Hello,

You are welcome!