This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hican someone advise how to extract the last/first few letters of a word/string with and without delimitorsan example from excel point of view:Left(Orange,2) = Orright(Orange,2) = gergds
can someone advise me a formulae for below case, i want to count the no.of invoices with invoice amount <>0case( Invoice Amount > 0, distinct( Invoice Number), '0' ))