Search results

thank you very much for your help finaly the function is like this: =Sum(IIf([monetary unit]="ITL";[amount];0)) =Sum(IIf([monetary unit]="USD";[amount];0)) if i have only ITL and USD but if i have different monetary units like ITL USD EUR... and i dont know each time which of all i have , it...

I have a report with products and prices but there are two types of prices ex:dollars and francs How can i have grand total of each group? product1 10 dollars product2 20 francs product3 15 dollars product4 30 francs product5 40 dollars i want to have grand total dollars: 65 dollars...