its working , but not correct results I want total sales amount with taxes ?? different formula ...???? ; ------------------------------------ daily sales [#Line: EI PartyLimit] Add : Field : After : EI CurrentBalance : TotSales4 [Field : TotSales4] Invisible : NOT ##CurBalanceFlag or NOT @@IsSales Field : Simple Prompt, Amount Field Local : Field : Simple Prompt : Info : $$LocaleString:"Total Sales as on date:" Local : Field : Simple Prompt : Width : 20 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 : deep cobalt blue Local : Field : Amount Field : Width : 22 [System : Formula] TrsTotSales : $$FromValue:$Date:$$ToValue:$Date:$AmoutTotals:Group:$$GroupSales
Check with this [System : Formula] TrsTotSales : IF $$IsEmpty:$$FromValue:$Date:$$ToValue:$Date:$CreditTotals:Group:$$GroupDirectIncomes then $$FromValue:$Date:$$ToValue:$Date:$CreditTotals:Group:$$GroupSales Else $$FromValue:$Date:$$ToValue:$Date:$CreditTotals:Group:$$GroupDirectIncomes
;Try This [System : Formula] TrsTotSales : $$FromValue@Bookfromdate:$$ToValue:$Date:$AmoutTotals:Group:$$GroupSales
I think you need to create a custom Function for that, In general sales amount does not include tax why you want like that.?