# This title is used **URL:** \ **Category:** Q&A\ **Tags:** parameters, tables, calculations, Business-Intelligence-Engineer, quick-sight\ **Created:** [April 25, 2025, 8:48am UTC](https://community.amazonquick.com/t/this-title-is-used/45412 "2025-04-25T08:48:15Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Kavtya](https://avatars.discourse-cdn.com/v4/letter/k/c6cbf5/32.png) [@Kavtya](https://community.amazonquick.com/u/Kavtya)\ **Post date:** [April 25, 2025, 8:48am UTC](https://community.amazonquick.com/t/this-title-is-used/45412/1 "2025-04-25T08:48:15Z")
I have want to perform this query sumIf( {portfolio\_outstanding}/10000000, truncDate(‘DD’, {new\_date}) = parseDate(‘2024-12-31’, ‘yyyy-MM-dd’) ) in i dont have this ({portfolio\_outstanding}/10000000)= as column i have created calculated measured Colum of it i just start using quicksight please any one can help it is argent please ping on what sup 8390607946 ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [April 25, 2025, 3:04pm UTC](https://community.amazonquick.com/t/this-title-is-used/45412/2 "2025-04-25T15:04:44Z")
Hi @Kavtya, I noticed that you made your question title ‘This title is used’..is that the error message you’re receiving from trying to make your calculated field? Additionally, sumIf’s can be a little tricky sometimes when trying to do too much, you could try reworking this as an ifelse statement instead, may look something like: > ifelse(truncDate(‘DD’, {new\_date}) = parseDate(‘2024-12-31’, ‘yyyy-MM-dd’), {portfolio\_outstanding}, NULL)/10000000 If that shows errors, you could try this option out as well: > sum(ifelse(truncDate(‘DD’, {new\_date}) = parseDate(‘2024-12-31’, ‘yyyy-MM-dd’), {portfolio\_outstanding}, NULL))/10000000 Last thing to mention, as this is a public forum, please refrain from sharing personal information or topic may get blocked. Thank you! ---
**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\ **Post date:** [April 26, 2025, 4:35am UTC](https://community.amazonquick.com/t/this-title-is-used/45412/3 "2025-04-26T04:35:12Z")
Hi @Kavtya - Can you please provide more details. Please mail me or connect offline to discuss the problem first and then guide you the right solution approach. Regards - Sanjeeb ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [May 5, 2025, 6:42pm UTC](https://community.amazonquick.com/t/this-title-is-used/45412/4 "2025-05-05T18:42:59Z")
Hi @Kavtya, Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your post or were you able to find a work around in the interim? If we do not hear back within the next 3 business days, I’ll close out this topic. Thank you! ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [May 8, 2025, 4:02pm UTC](https://community.amazonquick.com/t/this-title-is-used/45412/5 "2025-05-08T16:02:56Z")
Hi @Kavtya, Since we have not heard back, I’ll go ahead and close out this topic. However, if you have additional questions, feel free to create a new post in the community. Thank you! ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [May 8, 2025, 4:02pm UTC](https://community.amazonquick.com/t/this-title-is-used/45412/6 "2025-05-08T16:02:59Z")