# Can I have SumIF using LAC-A functions/ by another way on Quick Sight?

**URL:** <https://community.amazonquick.com/t/can-i-have-sumif-using-lac-a-functions-by-another-way-on-quick-sight/8140>\
**Category:** Q&A\
**Tags:** calculations, quick-sight\
**Created:** [December 1, 2022, 11:06pm UTC](https://community.amazonquick.com/t/can-i-have-sumif-using-lac-a-functions-by-another-way-on-quick-sight/8140 "2022-12-01T23:06:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rawatprr](https://avatars.discourse-cdn.com/v4/letter/r/f19dbf/32.png) [@rawatprr](https://community.amazonquick.com/u/rawatprr)\
**Post date:** [December 1, 2022, 11:06pm UTC](https://community.amazonquick.com/t/can-i-have-sumif-using-lac-a-functions-by-another-way-on-quick-sight/8140/1 "2022-12-01T23:06:51Z")

</div>

Calculation on Tableau:-

ifnull({Include [Org Rollup],[Prod Group],[Productivity Grouping], [Cluster], [cluster\_name], [cost\_center]: SUM(IF [NewScenario] = [Scenario 1] and [Year Num] = [Scenario 1 Year] then ifnull(zn([Ringfenced Emp Exp USD]),0) end)},0)

---

<div class="post-metadata">

**Author:** ![sagmukhe](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sagmukhe/32/22033_2.png) [@sagmukhe](https://community.amazonquick.com/u/sagmukhe)\
**Post date:** [December 2, 2022, 9:06am UTC](https://community.amazonquick.com/t/can-i-have-sumif-using-lac-a-functions-by-another-way-on-quick-sight/8140/2 "2022-12-02T09:06:57Z")

</div>

Similar thing is achievable using SUM and ifelse constructs in Quick Sight. The expression construct will look something like below. Hope this helps. In case, this answers your query, please mark this as the “Solution”. Thanks!

![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/c/c0c772ff2f669f24c2ec640ad6033a72d22d7050.png)

---

<div class="post-metadata">

**Author:** ![sagmukhe](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sagmukhe/32/22033_2.png) [@sagmukhe](https://community.amazonquick.com/u/sagmukhe)\
**Post date:** [December 6, 2022, 11:50am UTC](https://community.amazonquick.com/t/can-i-have-sumif-using-lac-a-functions-by-another-way-on-quick-sight/8140/3 "2022-12-06T11:50:18Z")

</div>

Hello @rawatprr Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!

---

<div class="post-metadata">

**Author:** ![rawatprr](https://avatars.discourse-cdn.com/v4/letter/r/f19dbf/32.png) [@rawatprr](https://community.amazonquick.com/u/rawatprr)\
**Post date:** [December 7, 2022, 6:17am UTC](https://community.amazonquick.com/t/can-i-have-sumif-using-lac-a-functions-by-another-way-on-quick-sight/8140/4 "2022-12-07T06:17:26Z")

</div>

Thanks @sagmukhe. The solution works.