3,920 questions
if function in fast report
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 21%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGR%3C/text%3E%3C/svg%3E)
gholamreza rezaie
61
Reputation points
hello my friends i write this function but i doesent result.
( like image )
this code :
[IIf([InvoiceItem.SecondaryQuantity]>0,[InvoiceItem.Price]/[InvoiceItem.SecondaryQuantity],[InvoiceItem.Fee])]
Microsoft 365 and Office | Excel | For business | Windows
SQL Server | Other
14,500 questions
{count} votes
-
Sander van de Velde | MVP 36,766 Reputation points MVP Volunteer Moderator2023-07-30T09:57:48.41+00:00 Hello, please add a picture and context.
What data is processed? What do you expect?
-
LiHongMSFT-4306 31,571 Reputation points2023-07-31T01:14:52.87+00:00 ( like image )
Please post the image. And we need more information, like some sample data along with your desired result.
-
Olaf Helper 47,441 Reputation points2023-07-31T06:57:20.9833333+00:00 Instead of a screenshot better post the code as code.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 18%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tanay Prasad 2,250 Reputation points2023-07-31T06:59:19.3033333+00:00 Hi can you please paste the code instead of image.
-
gholamreza rezaie 61 Reputation points
2023-08-01T10:44:26.6733333+00:00 this is my code :
[IIf([InvoiceItem.SecondaryQuantity]>0,[InvoiceItem.Price]/[InvoiceItem.SecondaryQuantity],[InvoiceItem.Fee])]
-
gholamreza rezaie 61 Reputation points
2023-08-02T05:44:06.8366667+00:00 @Tanay Prasad [IIf([InvoiceItem.SecondaryQuantity]>0,[InvoiceItem.Price]/[InvoiceItem.SecondaryQuantity],[InvoiceItem.Fee])]
-
gholamreza rezaie 61 Reputation points
2023-08-02T05:45:09.14+00:00 @Olaf Helper [IIf([InvoiceItem.SecondaryQuantity]>0,[InvoiceItem.Price]/[InvoiceItem.SecondaryQuantity],[InvoiceItem.Fee])]
-
Tanay Prasad 2,250 Reputation points
2023-08-02T06:47:35.7266667+00:00 You have used IIf, but in Excel we only use If.
Here's the updated code-
=IF([InvoiceItem.SecondaryQuantity]>0, [InvoiceItem.Price]/[InvoiceItem.SecondaryQuantity], [InvoiceItem.Fee])Try this and let me know.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Barry Schwarz 3,746 Reputation points2023-08-02T06:58:10.61+00:00 Normally, you multiply price and quantity to get total cost. You show division.
Sign in to comment
Sign in to answer