robertsb41
Contributor III
2020-07-02
10:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set Analysis Will Not Work when trying to Using Another Field
sum({< ABC_Bid_Amount={"<Low_Comp_Bid"}>} ABC_Bid_Amount)
My expression works great if I replace Low_Comp_Bid with a value like 1000000. It always returns 0 if I use any other field and not a value. What am I missing?
Thanks!
569 Views
1 Solution
Accepted Solutions
Taoufiq_Zarra
MVP
2020-07-02
10:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maye be :
=sum({<ABC_Bid_Amount={"=ABC_Bid_Amount<Low_Comp_Bid"}>} ABC_Bid_Amount)
If i understood correctly the request
Regards,
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
3 Replies
Taoufiq_Zarra
MVP
2020-07-02
10:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maye be :
=sum({<ABC_Bid_Amount={"=ABC_Bid_Amount<Low_Comp_Bid"}>} ABC_Bid_Amount)
If i understood correctly the request
Regards,
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
wayne-a
Creator
2020-07-02
11:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See this community post, it uses a somewhat obscure function.
537 Views
robertsb41
Contributor III
2020-07-02
03:32 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you!
510 Views