This title is used

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

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!

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

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!

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!