Nigtellios

If field with percent value > 0, subtract % from field or show other field.

if(
	prop("PERCENT") > 0,
	subtract(
		toNumber(prop("VALUE A")),
		multiply(divide(prop("PERCENT"), 100), toNumber(prop("VALUE A")))
	),
	prop("VALUE B")

Nigtellios

If you're getting the following error:

npm ERR! command C:\Windows\system32\cmd.exe /d /s /c node ./scripts/install.js || node-gyp rebuild
npm ERR! info install installing standalone, skipping download.
npm ERR! gyp ERR! find VS
npm ERR! gyp ERR! find VS msvs_version not set from command line or npm config
npm ERR! gyp ERR! find VS running in VS Command Prompt, installation path is:
npm ERR! gyp ERR! find VS "C:\Program Files\Microsoft Visual Studio\2022\Community\VC\Tools\MSVC"
npm ERR! gyp ERR! find VS - will only use this version

Nigtellios

1. Go into your C:\User\<USER> with your terminal.
2. Run command mkdir ~/bash_completion.d
3. Run command curl -o ~/bash_completion.d/git https://raw.githubusercontent.com/git/git/master/contrib/completion/git-completion.bash
4. Run command echo "source ~/bash_completion.d/git" >> ~/.bashrc

Now you can look for completions with TAB.

Nigtellios

1. Install Git for windows (with Git Bash)
2. Check option "Add profile for Windows Terminal" during installation
3. After successfull installation create a file .bashrc in your C:\Users<USER>
4. Populate the file with aliases as follows: alias <NAME>='<COMMAND>' You can also use a multiline aliases like:

<ALIAS>() {
   <COMMAND_1>
 

Nigtellios

If you're using msys2: microsoft/vscode#4651 (comment)

If not, just try this command: git config --global --add safe.directory '*'

Helped in my case. Cheers.

Nigtellios

1. Give Full Disk Access to your terminal.
2. Run sudo chown -R $(whoami) "/Applications/Visual Studio Code.app"