AHMEDRASHED
Member
- Local time
- Today, 02:35
- Joined
- Feb 2, 2020
- Messages
- 50
How i mange it please to calcculte Total selling based on format filed curancey (sellamountindivual+sellamountindivualgroup) * (usd or syp or eur )
if filed SellAmount format = AED then SumSF = =Sum([SellAmountIndividual])+Sum([SellAmountGroup])
if filed SellAmount format = USD then SumSF = =Sum([SellAmountIndividual])+Sum([SellAmountGroup])*TextUSD
if filed SellAmount format = EUR then SumSF = =Sum([SellAmountIndividual])+Sum([SellAmountGroup])*TextEUR
if filed SellAmount format = SYP then SumSF = =Sum([SellAmountIndividual])+Sum([SellAmountGroup])*TextSYP
if filed SellAmount format = AED then SumSF = =Sum([SellAmountIndividual])+Sum([SellAmountGroup])
if filed SellAmount format = USD then SumSF = =Sum([SellAmountIndividual])+Sum([SellAmountGroup])*TextUSD
if filed SellAmount format = EUR then SumSF = =Sum([SellAmountIndividual])+Sum([SellAmountGroup])*TextEUR
if filed SellAmount format = SYP then SumSF = =Sum([SellAmountIndividual])+Sum([SellAmountGroup])*TextSYP
Attachments
Last edited: