I found this code somewhere on net it shows the todays toal Purchase without GST what is the formula for with GSt Purchase Amount [#Line: EI PartyLimit] Add : Field : After : EI CurrentBalance : TotSales [Field : TotSales] Invisible : NOT ##CurBalanceFlag or NOT @@IsSales Field : Simple Prompt, Amount Field Local : Field : Simple Prompt : Info : $$LocaleString:"Today'sTotal Sale:" Local : Field : Simple Prompt : Width : 14 Local : Field : Amount Field : Set as : @@TrsTotSales Local : Field : Amount Field : Format : "Symbol,DrCr" Local : Field : Amount Field : Set always : Yes Local : Field : Amount Field : Color : Blue [System : Formula] TrsTotSales : $$FromValue:$Date:$$ToValue:$Date:$CreditTotals:Group:$$GroupSales ;;TrsTotSales : $$ToValue:$Date:$CreditTotals:Group:$$GroupSales I found this code somewhere on net it shows todays total sales but it shows withou gst amout what will be the formula for with GST sales amout [#Line: EI PartyLimit] Add : Field : After : EI CurrentBalance : TotPurch [Field : TotPurch] Invisible : NOT ##CurBalanceFlag or NOT @@IsPurchase Field : Simple Prompt, Amount Field Local : Field : Simple Prompt : Info : $$LocaleString:"Today's Total Purchase:" Local : Field : Simple Prompt : Width : 14 Local : Field : Amount Field : Set as : @@TrsTotPurch Local : Field : Amount Field : Format : "Symbol,DrCr" Local : Field : Amount Field : Set always : Yes Local : Field : Amount Field : Color : Blue [System : Formula] TrsTotPurch : $$FromValue:$Date:$$ToValue:$Date:$DebitTotals:Group:$$GroupPurchase ;;TrsTotPurch : $$ToValue:$Date:$DebitTotals:Group:$$GroupPurchase
The solution already exists on this forum. Please search for it. you can use the same in the formula to get your results.