Dear all,
I have a dashboard where I now can find the five largest transactions from an excel table based on user input (thanks NARAYANK991). I want to develop my model further and substitue the manually updated excel table with a table that is fed directly from a few SQL tables.
My problem is that the user inputs (or rather chooses from a combo box) numeric BranchIDs (as other tables have numeric BranchIDs) and the BranchID in the table resulting from the SQL query is text.
When I have '1116 as input, it works. When I try =text(a1;"0"), it does not.
This seems illogical to me. When I check the result with ISTEXT I get "true".
I suppose that there are workarounds, my first thought was to have the numeric userinput look up a corresponding text value, but it seems illogical and errorprone. I assume that the above must have a simple solution.
Kind regards
Bjorn
I have a dashboard where I now can find the five largest transactions from an excel table based on user input (thanks NARAYANK991). I want to develop my model further and substitue the manually updated excel table with a table that is fed directly from a few SQL tables.
My problem is that the user inputs (or rather chooses from a combo box) numeric BranchIDs (as other tables have numeric BranchIDs) and the BranchID in the table resulting from the SQL query is text.
When I have '1116 as input, it works. When I try =text(a1;"0"), it does not.
This seems illogical to me. When I check the result with ISTEXT I get "true".
I suppose that there are workarounds, my first thought was to have the numeric userinput look up a corresponding text value, but it seems illogical and errorprone. I assume that the above must have a simple solution.
Kind regards
Bjorn
