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.
property condition not working
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
property condition not working
- Attachments
-
- property condition 1.png (105.01 KiB) Viewed 729 times
-
- property condition 2 (output).png (7.71 KiB) Viewed 729 times
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Re: property condition not working
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
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
Last edited by dmasterplan on Sat Apr 30, 2022 7:15 am, edited 1 time in total.
-
- Posts: 991
- Joined: Tue Sep 07, 2021 10:11 am
Re: property condition not working
Hello,
Ok.
Please let us know if you need any additional help.
Thank you.
Ok.
Please let us know if you need any additional help.
Thank you.
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Re: property condition not working
I will surely ask questions whenever I get issues and don't know how to resolve itMax Shamanov wrote: ↑Sat Apr 30, 2022 5:59 am Hello,
Ok.
Please let us know if you need any additional help.
Thank you.

Great Thanks!
-
- Posts: 991
- Joined: Tue Sep 07, 2021 10:11 am
Re: property condition not working
Hello,
You are welcome!
You are welcome!