Hello! Looking for help with this. Our systems adm...
# general
d
Hello! Looking for help with this. Our systems admin who helped create some of our reports built this saved search for me. I am trying to make 4 new columns of info: • Yesterday Est Margin % • LY (last year) Est Margin % • YTD Est Margin % • YTD LY Est Margin % I am unsuccessful. Can anyone please help with how the formulas should be written? I attached a screenshot and highlighted the two formulas that my previous admin wrote. Thank you in advance! Dan
a
@Dan Valdez You could ask the same in #C2A1ZEMF0
though my 2 cents
based on your columns output you could use formula(text),formula(number),formula(date),formula(percent)
and you could simply add + , - and / in formula number type or you case statement
you can also refer 10101 answer id in suite answer
👍 1