Data & Schema Discussions
The dataverse runs deep. Get help with connections, loading, schema development, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Session Variable forCurrent and Past two years

Hi,Period_Name like 08-25,09-25 .i want to Create a formula column Year from Period name and store Current year and past two years in that year column like below . Next year dynamically change the values to 2024,2025 and 2026. Please let me know how ...

KHK_1-1762790489767.png
KHK by Partner
  • 33 Views
  • 0 replies
  • 0 kudos

Rename column name in Business view

Hi,I have added Invoice_amount column from AP_Invoices_all table and trying to add Invoice_amount column from AP_Invoice_Distributuons_All table in Business view.After adding Invoice_Amount column from second table in BV Column Name already exists me...

KKR_0-1761659874066.png
KKR by Rocketeer
  • 149 Views
  • 1 replies
  • 0 kudos

SQL Database Built in Functions

I'm having difficulty finding the documentation on the viable SQL Database Functions. I'm looking to see if it's possible to use any kind of TRIM() function during table definition, and can't seem to find the right page. Please see the attached scree...