You need to sign in to do that
Don't have an account?
Alphonse Onyeagwa
Has anyone calculate a variance between two fields in summary format report?
Hi, All,
I am trying to calculate a variance between 2 fields. I have the following in my formula, but is picking up on Opportunity name only, we would like to see it by each quote line, and I was wondering if anyone can point out what I may be doing wrong? Thanks!
OpportunityLineItem.SBQQ__QuoteLine__c.Displayed_Net_Total__c:SUM - PREVGROUPVAL(OpportunityLineItem.SBQQ__QuoteLine__c.Displayed_Net_Total__c:SUM, Opportunity.Name)
I am trying to calculate a variance between 2 fields. I have the following in my formula, but is picking up on Opportunity name only, we would like to see it by each quote line, and I was wondering if anyone can point out what I may be doing wrong? Thanks!
OpportunityLineItem.SBQQ__QuoteLine__c.Displayed_Net_Total__c:SUM - PREVGROUPVAL(OpportunityLineItem.SBQQ__QuoteLine__c.Displayed_Net_Total__c:SUM, Opportunity.Name)