Skip to main content
edited tags
Link
Adrian Larson
  • 151.3k
  • 38
  • 247
  • 431
added 20 characters in body
Source Link
Martin Lezer
  • 7.3k
  • 5
  • 27
  • 41

I have face the problem,i need to calculate the final amount if there is any booking fee and we charge service tax as 15% ST. If there is no Booking Fee then no ST,and if discount is there then we minus discount(percentage field) from the ticket price. It was working fine but now we offer discount amount(currency),but is not working.

My formula is

( (Quantity* UnitPrice ) - Discount_Amount__c ) + Booking_Fees_Amount__c + ((((Quantity* UnitPrice ) - Discount_Amount__c )+ Booking_Fees_Amount__c)*PG__c) + ST_15_on_Booking_Fees__c

( (Quantity* UnitPrice ) - Discount_Amount__c ) + 
Booking_Fees_Amount__c + 
((((Quantity* UnitPrice ) - Discount_Amount__c )+ Booking_Fees_Amount__c)*PG__c) + 
ST_15_on_Booking_Fees__c

Discount_Amount_cDiscount_Amount_c is Percentage and Discount_cDiscount_c is Currency.

In my case sometime we give Discount percentage as well as whole amount percentage is working fine but whole amount is not working fine

I have face the problem,i need to calculate the final amount if there is any booking fee and we charge service tax as 15% ST. If there is no Booking Fee then no ST,and if discount is there then we minus discount(percentage field) from the ticket price. It was working fine but now we offer discount amount(currency),but is not working.

My formula is

( (Quantity* UnitPrice ) - Discount_Amount__c ) + Booking_Fees_Amount__c + ((((Quantity* UnitPrice ) - Discount_Amount__c )+ Booking_Fees_Amount__c)*PG__c) + ST_15_on_Booking_Fees__c

Discount_Amount_c is Percentage and Discount_c is Currency.

In my case sometime we give Discount percentage as well as whole amount percentage is working fine but whole amount is not working fine

I have face the problem,i need to calculate the final amount if there is any booking fee and we charge service tax as 15% ST. If there is no Booking Fee then no ST,and if discount is there then we minus discount(percentage field) from the ticket price. It was working fine but now we offer discount amount(currency),but is not working.

My formula is

( (Quantity* UnitPrice ) - Discount_Amount__c ) + 
Booking_Fees_Amount__c + 
((((Quantity* UnitPrice ) - Discount_Amount__c )+ Booking_Fees_Amount__c)*PG__c) + 
ST_15_on_Booking_Fees__c

Discount_Amount_c is Percentage and Discount_c is Currency.

In my case sometime we give Discount percentage as well as whole amount percentage is working fine but whole amount is not working fine

Source Link
Sakthi S
  • 95
  • 1
  • 15

Formula for Discount calculation

I have face the problem,i need to calculate the final amount if there is any booking fee and we charge service tax as 15% ST. If there is no Booking Fee then no ST,and if discount is there then we minus discount(percentage field) from the ticket price. It was working fine but now we offer discount amount(currency),but is not working.

My formula is

( (Quantity* UnitPrice ) - Discount_Amount__c ) + Booking_Fees_Amount__c + ((((Quantity* UnitPrice ) - Discount_Amount__c )+ Booking_Fees_Amount__c)*PG__c) + ST_15_on_Booking_Fees__c

Discount_Amount_c is Percentage and Discount_c is Currency.

In my case sometime we give Discount percentage as well as whole amount percentage is working fine but whole amount is not working fine