0

Using a Page

Hello

I have a table with my billing in different currencies.

I have created a page where I want to graph my sales in Soles (Yes, I am from Peru).

On the page I have created a field where I put the exchange rate of the day; 'T.C.'.
When calling my billing table using select 'Billing', it no longer lets me use the 'T.C.' field.

How can I do this?

Thanks for your help

1 reply

null
    • Mel_Charles
    • 1 mth ago
    • Reported - view

    I am not sure how you want ti use it in your view but

    You will need to use a variable to to store the value for T.C.

    Then reference it in your select query depending on what your query is intended to do

    is like one of my examples

     

    on the form i have a filed called Company search

    thus I have declared a variable - myRef

    in the query on the table view I have 

    let myRef := CompanySearch;
    do as server
        select Contacts where Customers.Company like myRef
    end

Content aside

  • Status Answered
  • 1 mth agoLast active
  • 1Replies
  • 43Views
  • 2 Following