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
aaz
01/07/2020, 1:53 PM
@Dan Valdez You could ask the same in #C2A1ZEMF0
aaz
01/07/2020, 1:54 PM
though my 2 cents
aaz
01/07/2020, 1:55 PM
based on your columns output you could use formula(text),formula(number),formula(date),formula(percent)
aaz
01/07/2020, 1:55 PM
and you could simply add + , - and / in formula number type or you case statement
aaz
01/07/2020, 1:56 PM
you can also refer 10101 answer id in suite answer