Incorta
Community
Learn
Docs
Support
How to enable Javascript
Login
Sign Up
Login
Search
Home
Latest Posts
0
How to get difference for 2 consecutive days when using pivot table
I want to create a dashboard that has filter condition to check the difference between current value and prior value ie. Increase> 50000000 and Increase% > 0.05.…
Snehal Nandagawli
TCS
Snehal_Nandagawli
6 mths ago
1
reply
24
Questions & Answers
Re: How to define "OR" function in incorta
You can use if else also but I prefer using case: case( inlist([Line Type], "CREDIT_ONLY_NOAPPROV_LINE,BILL_ONLY_LINE,REBILL_BILL_ONLY,CA_BILL_ONLY,CA_CREDIT_ONLY,CA_REBILL_BILL_ONLY"), 0,…
Snehal Nandagawli
TCS
Snehal_Nandagawli
10 mths ago
1
Questions & Answers
Reported - view
Re: Subtotal and total not showing up for table insight
@Phil Pollard I am trying for xlsx
Snehal Nandagawli
TCS
Snehal_Nandagawli
10 mths ago
Questions & Answers
Reported - view
0
Subtotal and total not showing up for table insight
For a table insight, I have marked the subtotal and total in the insight settings and it is visible in the dashboard but when I download it in excel, the subtotal doesn't show.…
Snehal Nandagawli
TCS
Snehal_Nandagawli
10 mths ago
6
replies
26
Questions & Answers
Re: How to use WHERE in Incorta?
@Siva Kowsika Thank you ! This worked.
Snehal Nandagawli
TCS
Snehal_Nandagawli
10 mths ago
Questions & Answers
Reported - view
Re: How to use WHERE in Incorta?
@Siva Kowsika Hey I am creating a table. I need this formula as column1= Sum(amount) Where (Code InList ("abc, xyz")) and column2 = Sum(amount) due to which I cannot apply filter at insight level.
Snehal Nandagawli
TCS
Snehal_Nandagawli
10 mths ago
Questions & Answers
Reported - view
1
How to use WHERE in Incorta?
I have a BO variable that I am trying to replace in Incorta : Sum(amount) Where (Code InList ("abc, xyz")) How can I achieve this in Incorta?
Snehal Nandagawli
TCS
Snehal_Nandagawli
10 mths ago
4
replies
38
1
Questions & Answers
Snehal Nandagawli
Snehal_Nandagawli
TCS
IT
India
7
2
1
Follow
Login
Sign Up
Home
Community
Questions & Answers
Implementation Best Practices
Events
Knowledge Base
Product Announcements
Learn
Help Articles
Product Videos
Introduction to Incorta (17 Videos)
How To Videos
Tags
View all tags
Product Announcement
Incorta 4.9
is now Generally Available (GA)!!!